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 |