Data Element list used by SAP ABAP Table QSYSCOLUMN (iSeries: System Catalog View of Table Fields (SYSCOLUMNS))
SAP ABAP Table
QSYSCOLUMN (iSeries: System Catalog View of Table Fields (SYSCOLUMNS)) is using
| # | Object Type | Object Name | Object Description | Note |
|---|---|---|---|---|
| 1 | CCSID | iSeries: Table field CCSID | ||
| 2 | CHARBYTE | iSeries: Table field no. of character bytes | ||
| 3 | CHARLEN | iSeries: Maximum length of a character column | ||
| 4 | COLTYPE | iSeries: Table field data type | ||
| 5 | COL_LABEL | iSeries: Table field column heading | ||
| 6 | COL_NAME | iSeries: SQL column name | ||
| 7 | DATPRC | iSeries: Table fields date/time precision | ||
| 8 | DFTVALUE | iSeries: Table field default value | ||
| 9 | HASDEFAULT | iSeries: Table field has default | ||
| 10 | LABELTEXT | iSeries: Table field lable text | ||
| 11 | LENGTH | iSeries: Table field length | ||
| 12 | NULLS | iSeries: Table field is nullable | ||
| 13 | NUM_SCALE | iSeries: Table field numeric scale | ||
| 14 | ORD_POS | iSeries: Ordinal position of field in the table | ||
| 15 | PRECISION | iSeries: Table field numeric precision | ||
| 16 | RADIX | iSeries: Table field RADIX, precision of numeric fie | ||
| 17 | REMARKS | iSeries: Long comment of a table, view or table field | ||
| 18 | STORAGE | iSeries: Table field storage requirement | ||
| 19 | SYS_CNAME | iSeries: iSeries system column name | ||
| 20 | SYS_DNAME | iSeries: iSeries system name of table/view schema | ||
| 21 | SYS_TNAME | iSeries: iSeries system name of table or view | ||
| 22 | TAB_SCHEMA | iSeries: SQL schema name of table or view | ||
| 23 | TBCREATOR | iSeries: Owner of table or view | ||
| 24 | TBNAME | iSeries: SQL Name of Table or View | ||
| 25 | UPDATES | iSeries: Table field is updatable |