I am loading data into sequential file , while loading null values I am getting below warning
Sequential_File_2: When checking operator: When validating export schema: At field "A": "null_field" length (0) must match field's fixed width (3)
Thanks in Advance for your suggestions
I am getting warning while loading data into sequential file
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 111
- Joined: Thu Jun 01, 2006 5:12 am
- Location: Detroit
I am getting warning while loading data into sequential file
kOTI,
1586-738-7785
1586-738-7785
Check the field "A", if its fixed width, the null field value that you have specified as default doesn't match the given length. It should be of 3 digit.
Search for ""null_field" length (0) must match field's fixed width (3)" for all match.
Search for ""null_field" length (0) must match field's fixed width (3)" for all match.
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'
-
- Participant
- Posts: 111
- Joined: Thu Jun 01, 2006 5:12 am
- Location: Detroit
Thx Kumar,
As per my knowledge we 2 options to overcome this , but @ field level option we have problem with maximum length and maximum number of fields and secomd one is file properties there I was succeded in Old project but now it's not working and it's throuning that warniing, If it should be same with every field width is problem at file properties right,
Earlier I was used file properties and set it as nullfiled value = ' ' like it's done, Now i am getting warnings
Pls share your experience
Thanks In Advance
As per my knowledge we 2 options to overcome this , but @ field level option we have problem with maximum length and maximum number of fields and secomd one is file properties there I was succeded in Old project but now it's not working and it's throuning that warniing, If it should be same with every field width is problem at file properties right,
Earlier I was used file properties and set it as nullfiled value = ' ' like it's done, Now i am getting warnings
Pls share your experience
Thanks In Advance
kOTI,
1586-738-7785
1586-738-7785
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
If the data type is Char(3) then the Null Field Value property must contain three characters.
Indeed, any value in the field must contain exactly three characters.
Null Field Value is an example of an in-band null. An import operator converts it into an out-of-band null.
Indeed, any value in the field must contain exactly three characters.
Null Field Value is an example of an in-band null. An import operator converts it into an out-of-band null.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
you should use a MODIFY stage to specify explicit values for nullable columns before you send them to a sequentail file.
If you don't need nullable columns in the target (assuming that your sequentail file is a reject file or something like that and your target is a dataset or DB stage) then you should do this in the very beginning just afetr the input stage.
If you don't need nullable columns in the target (assuming that your sequentail file is a reject file or something like that and your target is a dataset or DB stage) then you should do this in the very beginning just afetr the input stage.
Mike