15.00 - HELP ERROR TABLE - Teradata Database

Teradata Database SQL Data Definition Language Detailed Topics

Product
Teradata Database
Release Number
15.00
Content Type
Programming Reference
Publication ID
B035-1184-015K
Language
English (United States)

HELP ERROR TABLE

System‑Defined Attribute Characteristics for the Error Table‑Specific Columns

The system‑defined and generated error table‑specific columns have the following characteristics:

 

Column Name

Data Type

Nullable?

ETC_DBQL_QID

DECIMAL(18,0)

N0

ETC_DMLType

CHARACTER(1)

Yes

ETC_ErrorCode

INTEGER

N0

ETC_ErrSeq

INTEGER

N0

ETC_IndexNumber

SMALLINT

Yes

ETC_IdxErrType

CHARACTER(1)

Yes

ETC_RowId

BYTE(10)

Yes

ETC_TableId

BYTE(6)

Yes

ETC_FieldId

SMALLINT

Yes

ETC_RITableId

BYTE(6)

Yes

ETC_RIFieldId

SMALLINT

Yes

ETC_TimeStamp

TIMESTAMP(2)

N0

ETC_Blob

BLOB

Yes

See “System‑Defined Attribute Characteristics and Definitions for Error Table‑Specific Columns” on page 233 for more detailed information about these columns and SQL Data Definition Language for information on how to use them.