DSXchange

There should be more to the error than just the routine name, could you post that part as well?

ArndW,
Thanks for replying; following is the complete error I'm getting.

Address_IN..SEQ_Address.Lnk_Write_Address: nls_read_delimeter() - row 53, column STR_TYPE_CDE required column missing
Address_IN..SEQ_Address.Lnk_Write_Address: nls_read_delimeter() - row 54, column SERIAL_NUM required column missing
Address_IN..SEQ_Address.Lnk_Write_Address: nls_read_delimeter() - row 55, column POSTAL required column missing
Address_IN..SEQ_Address.Lnk_Write_Address: nls_read_delimeter() - row 56, column SERIAL_NUM required column missing
Address_IN..SEQ_Address.Lnk_Write_Address: nls_read_delimeter() - row 56, column RES_STAT required column missing


In error SERIAL_NUM is shown twice.

Thanks in Advance,
Narendra

nchincholikar wrote:ArndW,
Thanks for replying; following is the complete error I'm getting.

Address_IN..SEQ_Address.Lnk_Write_Address: nls_read_delimeter() - row 53, column STR_TYPE_CDE required column missing
Address_IN..SEQ_Address.Lnk_Write_Address: nls_read_delimeter() - row 54, column SERIAL_NUM required column missing
Address_IN..SEQ_Address.Lnk_Write_Address: nls_read_delimeter() - row 55, column POSTAL required column missing
Address_IN..SEQ_Address.Lnk_Write_Address: nls_read_delimeter() - row 56, column SERIAL_NUM required column missing
Address_IN..SEQ_Address.Lnk_Write_Address: nls_read_delimeter() - row 56, column RES_STAT required column missing
In error SERIAL_NUM is shown twice.

Thanks in Advance,
Narendra

Is your file a fixed width file? In that case format the your output row such that total length of the record matches the length of the column specified in sequential file metadata.

The error, as balajisr has already pointed out, is not related to NLS but to your data and metadata; the error would happen even on non-NLS installations.
You can tell the sequential stage to ignore missing columns to get rid of these warnings, but only if this makes sense in your job design.