Underflow and Overflow conditions for BTEQ

Tools & Utilities

Underflow and Overflow conditions for BTEQ

Hello All,

I'm trying to import a tab delimited file into a table.

Overflow condition = number of delimited values of record in import file > number of columns in table

 Behavior – BTEQ silently ignoring the overflow columns that are at the end of the record.

Underflow condition = number of delimited values of a record in import file < number of columns in table

 Behavior – returns Failure 2673.

Is there any BTEQ command that i can mention in load script so that BTEQ returns an error for overflown records as well?

Thanks, Ram.

Tags (1)