The system provides one dictionary table, DBC.ErrorTbls, and three views, DBC.ErrorTblsV, DBC.ErrorTblsVX, and DBC.Tables3VX, to support error tables.
DBC.ErrorTbls maintains the relationships between error tables and their data tables rather than the table header.
You can query the DBC.ErrorTblsV and DBC.ErrorTblsVX views to report error table names and their associated data table and database names.
You can query the DBC.Tables3VX view to report the database, table, and column names associated with the table IDs and column IDs stored in error table rows.
See X Views for the definitions and usage details about DBC.ErrorTbls, DBC.ErrorTblsV, DBC.ErrorTblsVX, and DBC.Tables3VX. See for an example of how to use the DBC.Tables3VX view.
Error Table Row Size Minimization
To minimize the size of error table rows, the system stores only the IDs of fields and users, not their names. To determine the names associated with the stored field IDs and user IDs, you can run queries against the DBC.Tables3VX view.
For example,
SELECT TableName, FieldName, ETC_ErrorCode FROM DBC.Tables3VX, ET_myerrtbl WHERE TableId = ETC_TableId AND FieldId = ETC_FieldId AND ETC_DBQL_QID = 385520516506583068;
- ET_myerrtbl
- The default system-generated name of the error table for base table myerrtbl, for which you want to retrieve table and column names.
- 385520516506583068
- The unique DBQL query ID for this request.
See Teradata® Parallel Data Pump Reference, B035-3021, Teradata® FastLoad Reference, B035-2411, and Teradata® MultiLoad Reference, B035-2409 for the definitions of the error tables generated by those bulk loading utilities.