Hi,
I have a parallel job and I'm writting data to sequential file and it had a field sv9 with char(10) data type and in the field properties I mentioned Null value as 'NULLNULLNU' to get rid of the waring
When validating export schema: At field "sv9": "null_field" length (4) must match field's fixed width (10)
but when I see the data in the file for NULL values it has a data NULLNULLNU instead of NULL . Is there a way in parallel job that I can have a value NULL for NULL fields for char(10) lenght column with out a warning message like in server job if you mention in properties NULL it will assign NULL value for all the fields irrespective of their lengths For example for field1 char(1) contains a NULL value it assigns NULL eventhough it is char(1). Is it possible in parallel job or do I need to mention varchar(4) for field1
Thanks,
Somaraju
Writting NULL to a sequential File
Moderators: chulett, rschirm, roy
Writting NULL to a sequential File
somaraju
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Premium Member
- Posts: 72
- Joined: Mon Jul 06, 2009 9:34 pm
- Location: Sydney
-
- Participant
- Posts: 57
- Joined: Wed Oct 21, 2009 4:46 am
- Location: India