HELP ERROR TABLE reports include the information in HELP TABLE reports and information about the error table-specific columns in the following table.
For more information about these columns, see System-Defined Attributes for 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 |
The attributes for the two reports are identical (see HELP MACRO).
See Example: HELP TABLE.
Information Returned by the Different Syntax Forms
The HELP ERROR TABLE information and attributes reported by either syntax are identical and to that returned by HELP TABLE, only for an error table rather than for a base data table.
See CREATE ERROR TABLE Usage Notes for more information about error tables.
See Macro Attributes for information and attributes returned by the syntaxes for the HELP ERROR TABLE statement. Also see CREATE TABLE and CREATE TABLE AS.