I have one column in the table defined as AAA1 decimal(9,2)
While doing fastload its throwing an error limit exceeded because its more than 9 numbers. My aim is to define the fastload file to remove the bad data from the table and to load remaining datas without causing any abend.
Is it possible??
Which format is used to load the data? VARTEXT or DATA?
In both cases DEFINE the input columns with matching datatypes (DEC(11,2) or VARCHAR(12)) and FastLoad should put those rows into the ET error table.
But if you want FastLoad to ignore that error and still load the row with a NULL instead you must switch to MultiLoad using NULLIF or load to a staging table and then use a CASE.
Isn't the abend occurring because of the Error Limit being set to some value?
The ErrorLimit command should be removed so that the job does not terminate during the acquisition phase after 'n' rows end up in the error table.