Page 1 of 1

sequential file warning

Posted: Thu Sep 08, 2011 8:19 am
by kennyapril
When checking operator: When validating export schema: At field "BANK_KEY": "null_field" length (1) must match field's fixed width (40)


The above warning is from a sequential file andto get rid of this warning I changed the null value to this particuler field to 40 in the column properties and now I do not see any warning.

Is there any other solution other than this to get rid of the warning as we do not want to see 40 spaces taken for a null value.


Thanks

Posted: Thu Sep 08, 2011 8:49 am
by chulett
For a fixed-width sequential file column, how else would you represent it?

Posted: Thu Sep 08, 2011 11:50 am
by kennyapril
Actually this is a file used for capturing rejects from a table.

Is there any way to remove the fixed length in that sequential file?