By default, the Stream Operator will create the error table. If the error table already exists, Stream Operator will terminate the job with an error message. The exception is on a job restart. On a job restart, Stream Operator will continue.
- When the value of the AppendErrorTable attributes is YES, the Stream operator reuses the error table and displays the number of rows already existing in the error table.
- If the error table does not exist, the Stream operator creates the error table before data loading and continue.
- If the structure of the existing error table is not compatible with the error table the Stream operator expects, it terminates the job with an error message before data loading.
A new column, RowInsertTime, was added to the Stream Operator error table for version 13.10. Therefore, you can no longer reuse error tables from prior versions, as valid Stream Operator error tables now have ten columns rather than nine.