I am not strong on BTEQ and I need help on what can be achieved with ‘.Error’.
I have to insert into a 60 row table a lot of non validated data (about 1 million rows). Every so often (twice a month) the script falls over because it comes to a record where a field is the wrong data type for its table (ie trying to insert ‘abc’ into a numeric data type field).
I wanted to use the Teradata clean string function but the boss says these is too resource intensive on a ten million row table. Is there a way to use ‘.Error’ to trap records and isolate them from further processing?