AM very new to teradata and trying to work on a TPT script. The script is being used for loading data from flat file to a staging table. Now we do get data sometimes which causes a datatype length overflow, the load terminates immediately on encountering such issues. Am looking for ways to contnue the loading process when the number of error records is lessser than a pre -defined number(say 5 records). is there an option with TPT to achieve this?
I see there is an option of rowErrorFileName, which would push all the error records into a error file and continue the loads. But the requirement is to have an upper threshhold of say 5 records(pre defined) and if the number of error records> 5 then the TPT load should terminate. please suggest. appreciate the help.
If you are using the LOAD operator then you probably want the ErrorLimit parameter.
I couldn't see the "rowErrorFileName" parameter for the LOAD operator, not sure where that comes from. For the LOAD operator you have ErrorTable1/2 parameters.
Thanks Dave. So as i understand, i could use the Error Limit option to set a threshold. If the bad records are lesser than the assigned threshold, then the loads still continue and the bad records are loaded to the error table.If the no. of error records> threshold then the loads are terminated.
In case of bad records lesser than the threshold , is there a way to push those records to a badfile than having to access the error tables to identify the bad records? appreciate the help.
Yes, your understanding is correct. No, the bad records can only be written to a table - it is the dbms code that detects the problem and that code doesn't send the rows back out to a file on your client/etl server. It only puts them into a table.