This error is not related to an error tables.
The problem is with your "checkpoint 1000" statement.
That is not valid.
You specify the checkpoint interval on the BEGIN LOADING command.
Please refer to the FastLoad reference manual for the correct syntax.
Thanks for all the response.
I am stuck in loading a timestamp column. Following is my script, can you pls help?
You say you are stuck, but do not give the problem.
I do see 2 things:
1. you still have not removed the checkpoint command; that is not valid
2. I do not believe you can provide CAST or FORMAT specifications in an INSERT statement for the FastLoad protocol (the DBS places a lot of restrictions on the syntax of the INSERT statement for the FastLoad protocol).
If you define the column properly in the target table (with the appropriate FORMAT string), I would think you can provide the data as either CHAR or VARCHAR and the DBS will convert.
You can use a typecast in FastLoad, but it must be Teradata style, not CAST :-)
(:dtime (TIMESTAMP(0), format 'yyyy-mm-ddbhh:mi:ss'))