/AWS1/CL_ATHCOLUMNINFO¶
Information about the columns in a query execution result.
CONSTRUCTOR¶
IMPORTING¶
Required arguments:¶
iv_name TYPE /AWS1/ATHSTRING /AWS1/ATHSTRING¶
The name of the column.
iv_type TYPE /AWS1/ATHSTRING /AWS1/ATHSTRING¶
The data type of the column.
Optional arguments:¶
iv_catalogname TYPE /AWS1/ATHSTRING /AWS1/ATHSTRING¶
The catalog to which the query results belong.
iv_schemaname TYPE /AWS1/ATHSTRING /AWS1/ATHSTRING¶
The schema name (database name) to which the query results belong.
iv_tablename TYPE /AWS1/ATHSTRING /AWS1/ATHSTRING¶
The table name for the query results.
iv_label TYPE /AWS1/ATHSTRING /AWS1/ATHSTRING¶
A column label.
iv_precision TYPE /AWS1/ATHINTEGER /AWS1/ATHINTEGER¶
For
DECIMALdata types, specifies the total number of digits, up to 38. For performance reasons, we recommend up to 18 digits.
iv_scale TYPE /AWS1/ATHINTEGER /AWS1/ATHINTEGER¶
For
DECIMALdata types, specifies the total number of digits in the fractional part of the value. Defaults to 0.
iv_nullable TYPE /AWS1/ATHCOLUMNNULLABLE /AWS1/ATHCOLUMNNULLABLE¶
Unsupported constraint. This value always shows as
UNKNOWN.
iv_casesensitive TYPE /AWS1/ATHBOOLEAN /AWS1/ATHBOOLEAN¶
Indicates whether values in the column are case-sensitive.
Queryable Attributes¶
CatalogName¶
The catalog to which the query results belong.
Accessible with the following methods¶
| Method | Description |
|---|---|
GET_CATALOGNAME() |
Getter for CATALOGNAME, with configurable default |
ASK_CATALOGNAME() |
Getter for CATALOGNAME w/ exceptions if field has no value |
HAS_CATALOGNAME() |
Determine if CATALOGNAME has a value |
SchemaName¶
The schema name (database name) to which the query results belong.
Accessible with the following methods¶
| Method | Description |
|---|---|
GET_SCHEMANAME() |
Getter for SCHEMANAME, with configurable default |
ASK_SCHEMANAME() |
Getter for SCHEMANAME w/ exceptions if field has no value |
HAS_SCHEMANAME() |
Determine if SCHEMANAME has a value |
TableName¶
The table name for the query results.
Accessible with the following methods¶
| Method | Description |
|---|---|
GET_TABLENAME() |
Getter for TABLENAME, with configurable default |
ASK_TABLENAME() |
Getter for TABLENAME w/ exceptions if field has no value |
HAS_TABLENAME() |
Determine if TABLENAME has a value |
Name¶
The name of the column.
Accessible with the following methods¶
| Method | Description |
|---|---|
GET_NAME() |
Getter for NAME, with configurable default |
ASK_NAME() |
Getter for NAME w/ exceptions if field has no value |
HAS_NAME() |
Determine if NAME has a value |
Label¶
A column label.
Accessible with the following methods¶
| Method | Description |
|---|---|
GET_LABEL() |
Getter for LABEL, with configurable default |
ASK_LABEL() |
Getter for LABEL w/ exceptions if field has no value |
HAS_LABEL() |
Determine if LABEL has a value |
Type¶
The data type of the column.
Accessible with the following methods¶
| Method | Description |
|---|---|
GET_TYPE() |
Getter for TYPE, with configurable default |
ASK_TYPE() |
Getter for TYPE w/ exceptions if field has no value |
HAS_TYPE() |
Determine if TYPE has a value |
Precision¶
For
DECIMALdata types, specifies the total number of digits, up to 38. For performance reasons, we recommend up to 18 digits.
Accessible with the following methods¶
| Method | Description |
|---|---|
GET_PRECISION() |
Getter for PRECISION |
Scale¶
For
DECIMALdata types, specifies the total number of digits in the fractional part of the value. Defaults to 0.
Accessible with the following methods¶
| Method | Description |
|---|---|
GET_SCALE() |
Getter for SCALE |
Nullable¶
Unsupported constraint. This value always shows as
UNKNOWN.
Accessible with the following methods¶
| Method | Description |
|---|---|
GET_NULLABLE() |
Getter for NULLABLE, with configurable default |
ASK_NULLABLE() |
Getter for NULLABLE w/ exceptions if field has no value |
HAS_NULLABLE() |
Determine if NULLABLE has a value |
CaseSensitive¶
Indicates whether values in the column are case-sensitive.
Accessible with the following methods¶
| Method | Description |
|---|---|
GET_CASESENSITIVE() |
Getter for CASESENSITIVE |
Public Local Types In This Class¶
Internal table types, representing arrays and maps of this class, are defined as local types:
TT_COLUMNINFOLIST¶
TYPES TT_COLUMNINFOLIST TYPE STANDARD TABLE OF REF TO /AWS1/CL_ATHCOLUMNINFO WITH DEFAULT KEY
.