17.10 - Error Table Row Size Minimization - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Detailed Topics

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-27
dita:mapPath
imq1591724555718.ditamap
dita:ditavalPath
imq1591724555718.ditaval
dita:id
jbg1472252759029

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.