Error nls_read_delimited()

ArndW · Post by **ArndW** » Fri Jun 16, 2006 4:31 am

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

nchincholikar · Post by **nchincholikar** » Fri Jun 16, 2006 5:29 am

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

balajisr · Post by **balajisr** » Fri Jun 16, 2006 5:43 am

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.

ArndW · Post by **ArndW** » Fri Jun 16, 2006 6:17 am

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.