Error tables are stored in the database. The following SQL requests access to the error tables shown in the in the examples in Reading Error Tables:
ErrorTable1
SELECT errorcode, errorfield, sourceseq, dmlseq from t2_e1;
If the operator definition does not specify a name for the ErrorTable1 attribute, the error table is named <TargetTableName>_ET by default.
If the Stream operator AppendErrorTable attribute is set to Yes, the Stream errors for the current job may be found in a table with errors from one or more previous jobs.
ErrorTable2
SELECT dbcerrorcode, sourceseq, dmlseq FROM t3_e2;
If the operator definition does not specify a name for the ErrorTable2 attribute, the error table is named <TargetTableName>_UV by default.
When accessing error tables, consider adding the expression ORDER BY ErrorCode.