sequential file warning

kennyapril · Post by **kennyapril** » Thu Sep 08, 2011 8:19 am

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

chulett · Post by **chulett** » Thu Sep 08, 2011 8:49 am

For a fixed-width sequential file column, how else would you represent it?

kennyapril · Post by **kennyapril** » Thu Sep 08, 2011 11:50 am

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?