Using Error in BTEQ

General
Enthusiast

Using Error in BTEQ

Hi ,

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?

Tags (1)
1 REPLY
Junior Contributor

Re: Using Error in BTEQ

Not using BTEQ, you must switch to a real load tool, TPump or TPT.