Table/Structure Field list used by SAP ABAP Class CL_DB4_SYSTEM_VIEWS (iSeries: Queries on System Catalog Views)
SAP ABAP Class 
CL_DB4_SYSTEM_VIEWS (iSeries: Queries on System Catalog Views) is using
Class Method (123)| # | Object Type | Object Name | Object Description | Note |
|---|---|---|---|---|
 |
|
|||
| 1 |  Table/Structure Field |
DB4SQLNAM - TABNAME | iSeries: Object Name | |
| 2 | Table/Structure Field |
DB4SQLNAM - TABNAME | iSeries: Object Name | |
| 3 | Table/Structure Field |
DB4SQLNAM - TABNAME | iSeries: Object Name | |
| 4 | Table/Structure Field |
DB4SQLNAM - TABNAME_LONG | iSeries: Object Name | |
| 5 | Table/Structure Field |
DB4SQLNAM - TABNAME_LONG | iSeries: Object Name | |
| 6 | Table/Structure Field |
DB4SQLNAM - TABNAME_LONG | iSeries: Object Name | |
| 7 | Table/Structure Field |
DB4_EXPLAIN - QQTLN | iSeries: System Name of Library (Database Monitor) | |
| 8 | Table/Structure Field |
DB4_EXPLAIN - QQTLN | iSeries: System Name of Library (Database Monitor) | |
| 9 | Table/Structure Field |
DB4_EXPLAIN - QQTLN | iSeries: System Name of Library (Database Monitor) | |
| 10 | Table/Structure Field |
DB4_EXPLAIN - QQTLN | iSeries: System Name of Library (Database Monitor) | |
| 11 | Table/Structure Field |
DB4_EXPLAIN - QQTLN | iSeries: System Name of Library (Database Monitor) | |
| 12 | Table/Structure Field |
DB4_EXPLAIN - QQTLN | iSeries: System Name of Library (Database Monitor) | |
| 13 | Table/Structure Field |
DB4_EXPLAIN - QQTLN | iSeries: System Name of Library (Database Monitor) | |
| 14 | Table/Structure Field |
DB4_EXPLAIN - QQTLN | iSeries: System Name of Library (Database Monitor) | |
| 15 | Table/Structure Field |
DB4_EXPLAIN - QQTLN | iSeries: System Name of Library (Database Monitor) | |
| 16 | Table/Structure Field |
DB4_EXPLAIN - QQTLN | iSeries: System Name of Library (Database Monitor) | |
| 17 | Table/Structure Field |
DB4_EXPLAIN - QQTLN | iSeries: System Name of Library (Database Monitor) | |
| 18 | Table/Structure Field |
DB4_EXPLAIN - QQTLN | iSeries: System Name of Library (Database Monitor) | |
| 19 | Table/Structure Field |
DB4_EXPLAIN - QQTLN | iSeries: System Name of Library (Database Monitor) | |
| 20 | Table/Structure Field |
DB4_EXPLAIN - QQTLN | iSeries: System Name of Library (Database Monitor) | |
| 21 | Table/Structure Field |
DB4_EXPLAIN - QQTLN | iSeries: System Name of Library (Database Monitor) | |
| 22 | Table/Structure Field |
DB4_EXPLAIN - QQTLN | iSeries: System Name of Library (Database Monitor) | |
| 23 | Table/Structure Field |
DB4_EXPLAIN - QQTLN | iSeries: System Name of Library (Database Monitor) | |
| 24 | Table/Structure Field |
DB4_EXPLAIN - QQTLN | iSeries: System Name of Library (Database Monitor) | |
| 25 | Table/Structure Field |
DB4_EXPLAIN - QQTLN | iSeries: System Name of Library (Database Monitor) | |
| 26 | Table/Structure Field |
DB4_EXPLAIN - QQTLN | iSeries: System Name of Library (Database Monitor) | |
| 27 | Table/Structure Field |
DBCON - CON_NAME | Logical name for a database connection | |
| 28 | Table/Structure Field |
DBCON - CON_NAME | Logical name for a database connection | |
| 29 | Table/Structure Field |
DD02V - TABNAME | Table Name | |
| 30 | Table/Structure Field |
DD02V - TABNAME | Table Name | |
| 31 | Table/Structure Field |
QSYSCOLUMN - CHARBYTE | iSeries: Table field no. of character bytes | |
| 32 | Table/Structure Field |
QSYSCOLUMN - CHARLEN | iSeries: Maximum length of a character column | |
| 33 | Table/Structure Field |
QSYSCOLUMN - COLNO | iSeries: Ordinal position of field in the table | |
| 34 | Table/Structure Field |
QSYSCOLUMN - COLTYPE | iSeries: Table field data type | |
| 35 | Table/Structure Field |
QSYSCOLUMN - DATPRC | iSeries: Table fields date/time precision | |
| 36 | Table/Structure Field |
QSYSCOLUMN - DBNAME | iSeries: SQL schema name of table or view | |
| 37 | Table/Structure Field |
QSYSCOLUMN - DFTVALUE | iSeries: Table field default value | |
| 38 | Table/Structure Field |
QSYSCOLUMN - LABELTEXT | iSeries: Table field lable text | |
| 39 | Table/Structure Field |
QSYSCOLUMN - LENGTH | iSeries: Table field length | |
| 40 | Table/Structure Field |
QSYSCOLUMN - NAME | iSeries: SQL column name | |
| 41 | Table/Structure Field |
QSYSCOLUMN - NULLS | iSeries: Table field is nullable | |
| 42 | Table/Structure Field |
QSYSCOLUMN - QPRECISION | iSeries: Table field numeric precision | |
| 43 | Table/Structure Field |
QSYSCOLUMN - Q_CCSID | iSeries: Table field CCSID | |
| 44 | Table/Structure Field |
QSYSCOLUMN - Q_DEFAULT | iSeries: Table field has default | |
| 45 | Table/Structure Field |
QSYSCOLUMN - Q_LABEL | iSeries: Table field column heading | |
| 46 | Table/Structure Field |
QSYSCOLUMN - RADIX | iSeries: Table field RADIX, precision of numeric fie | |
| 47 | Table/Structure Field |
QSYSCOLUMN - REMARKS | iSeries: Long comment of a table, view or table field | |
| 48 | Table/Structure Field |
QSYSCOLUMN - SCALE | iSeries: Table field numeric scale | |
| 49 | Table/Structure Field |
QSYSCOLUMN - STORAGE | iSeries: Table field storage requirement | |
| 50 | Table/Structure Field |
QSYSCOLUMN - SYS_CNAME | iSeries: iSeries system column name | |
| 51 | Table/Structure Field |
QSYSCOLUMN - SYS_DNAME | iSeries: iSeries system name of table/view schema | |
| 52 | Table/Structure Field |
QSYSCOLUMN - SYS_TNAME | iSeries: iSeries system name of table or view | |
| 53 | Table/Structure Field |
QSYSCOLUMN - TBCREATOR | iSeries: Owner of table or view | |
| 54 | Table/Structure Field |
QSYSCOLUMN - TBNAME | iSeries: SQL Name of Table or View | |
| 55 | Table/Structure Field |
QSYSCOLUMN - UPDATES | iSeries: Table field is updatable | |
| 56 | Table/Structure Field |
QSYSCST - CDBNAME | iSeries: SQL schema name of a constraint | |
| 57 | Table/Structure Field |
QSYSCST - CDBNAME | iSeries: SQL schema name of a constraint | |
| 58 | Table/Structure Field |
QSYSCST - CONST_TYPE | iSeries: Constraint type | |
| 59 | Table/Structure Field |
QSYSCST - CONST_TYPE | iSeries: Constraint type | |
| 60 | Table/Structure Field |
QSYSCST - INITDEFER | iSeries: Constraint defined as initially deferred (Yes/No) | |
| 61 | Table/Structure Field |
QSYSCST - INITDEFER | iSeries: Constraint defined as initially deferred (Yes/No) | |
| 62 | Table/Structure Field |
QSYSCST - ISDEFER | iSeries: Constraint checking can be deferred (Yes/No) | |
| 63 | Table/Structure Field |
QSYSCST - ISDEFER | iSeries: Constraint checking can be deferred (Yes/No) | |
| 64 | Table/Structure Field |
QSYSCST - RELNAME | iSeries: SQL constraint name | |
| 65 | Table/Structure Field |
QSYSCST - RELNAME | iSeries: SQL constraint name | |
| 66 | Table/Structure Field |
QSYSCST - RELNAME | iSeries: SQL constraint name | |
| 67 | Table/Structure Field |
QSYSCST - SYS_DNAME | iSeries: iSeries system name of table/view schema | |
| 68 | Table/Structure Field |
QSYSCST - SYS_DNAME | iSeries: iSeries system name of table/view schema | |
| 69 | Table/Structure Field |
QSYSCST - SYS_TNAME | iSeries: iSeries system name of table or view | |
| 70 | Table/Structure Field |
QSYSCST - SYS_TNAME | iSeries: iSeries system name of table or view | |
| 71 | Table/Structure Field |
QSYSCST - TBNAME | iSeries: SQL Name of Table or View | |
| 72 | Table/Structure Field |
QSYSCST - TBNAME | iSeries: SQL Name of Table or View | |
| 73 | Table/Structure Field |
QSYSCST - TDBNAME | iSeries: SQL schema name of table or view | |
| 74 | Table/Structure Field |
QSYSCST - TDBNAME | iSeries: SQL schema name of table or view | |
| 75 | Table/Structure Field |
QSYSINDEXS - COLCOUNT | iSeries: Number of columns in index key | |
| 76 | Table/Structure Field |
QSYSINDEXS - COLCOUNT | iSeries: Number of columns in index key | |
| 77 | Table/Structure Field |
QSYSINDEXS - IDXCREATOR | iSeries: Owner of index | |
| 78 | Table/Structure Field |
QSYSINDEXS - IDXCREATOR | iSeries: Owner of index | |
| 79 | Table/Structure Field |
QSYSINDEXS - IDX_SCHEMA | iSeries: SQL schema name of index | |
| 80 | Table/Structure Field |
QSYSINDEXS - IDX_SCHEMA | iSeries: SQL schema name of index | |
| 81 | Table/Structure Field |
QSYSINDEXS - IS_UNIQUE | iSeries: Unique rule of index | |
| 82 | Table/Structure Field |
QSYSINDEXS - IS_UNIQUE | iSeries: Unique rule of index | |
| 83 | Table/Structure Field |
QSYSINDEXS - NAME | iSeries: SQL index name | |
| 84 | Table/Structure Field |
QSYSINDEXS - NAME | iSeries: SQL index name | |
| 85 | Table/Structure Field |
QSYSINDEXS - NAME | iSeries: SQL index name | |
| 86 | Table/Structure Field |
QSYSINDEXS - SYS_DNAME | iSeries: iSeries system name of table/view schema | |
| 87 | Table/Structure Field |
QSYSINDEXS - SYS_DNAME | iSeries: iSeries system name of table/view schema | |
| 88 | Table/Structure Field |
QSYSINDEXS - SYS_IDNAME | iSeries: iSeries system index schema name | |
| 89 | Table/Structure Field |
QSYSINDEXS - SYS_IDNAME | iSeries: iSeries system index schema name | |
| 90 | Table/Structure Field |
QSYSINDEXS - SYS_IXNAME | iSeries: iSeries system index name | |
| 91 | Table/Structure Field |
QSYSINDEXS - SYS_IXNAME | iSeries: iSeries system index name | |
| 92 | Table/Structure Field |
QSYSINDEXS - SYS_TNAME | iSeries: iSeries system name of table or view | |
| 93 | Table/Structure Field |
QSYSINDEXS - SYS_TNAME | iSeries: iSeries system name of table or view | |
| 94 | Table/Structure Field |
QSYSINDEXS - TAB_SCHEMA | iSeries: SQL schema name of table or view | |
| 95 | Table/Structure Field |
QSYSINDEXS - TAB_SCHEMA | iSeries: SQL schema name of table or view | |
| 96 | Table/Structure Field |
QSYSINDEXS - TBCREATOR | iSeries: Owner of table or view | |
| 97 | Table/Structure Field |
QSYSINDEXS - TBCREATOR | iSeries: Owner of table or view | |
| 98 | Table/Structure Field |
QSYSINDEXS - TBNAME | iSeries: SQL Name of Table or View | |
| 99 | Table/Structure Field |
QSYSINDEXS - TBNAME | iSeries: SQL Name of Table or View | |
| 100 | Table/Structure Field |
QSYSKEYCST - CDBNAME | iSeries: SQL schema name of a constraint | |
| 101 | Table/Structure Field |
QSYSKEYCST - CDBNAME | iSeries: SQL schema name of a constraint | |
| 102 | Table/Structure Field |
QSYSKEYCST - COL_NAME | iSeries: SQL column name | |
| 103 | Table/Structure Field |
QSYSKEYCST - COL_NAME | iSeries: SQL column name | |
| 104 | Table/Structure Field |
QSYSKEYCST - COL_POS | iSeries: Ordinal position of field in the table | |
| 105 | Table/Structure Field |
QSYSKEYCST - COL_POS | iSeries: Ordinal position of field in the table | |
| 106 | Table/Structure Field |
QSYSKEYCST - COL_SEQ | iSeries: Position of column within the key/index | |
| 107 | Table/Structure Field |
QSYSKEYCST - COL_SEQ | iSeries: Position of column within the key/index | |
| 108 | Table/Structure Field |
QSYSKEYCST - RELNAME | iSeries: SQL constraint name | |
| 109 | Table/Structure Field |
QSYSKEYCST - RELNAME | iSeries: SQL constraint name | |
| 110 | Table/Structure Field |
QSYSKEYCST - SYS_CNAME | iSeries: iSeries system column name | |
| 111 | Table/Structure Field |
QSYSKEYCST - SYS_CNAME | iSeries: iSeries system column name | |
| 112 | Table/Structure Field |
QSYSKEYCST - SYS_DNAME | iSeries: iSeries system name of table/view schema | |
| 113 | Table/Structure Field |
QSYSKEYCST - SYS_DNAME | iSeries: iSeries system name of table/view schema | |
| 114 | Table/Structure Field |
QSYSKEYCST - SYS_TNAME | iSeries: iSeries system name of table or view | |
| 115 | Table/Structure Field |
QSYSKEYCST - SYS_TNAME | iSeries: iSeries system name of table or view | |
| 116 | Table/Structure Field |
QSYSKEYCST - TBCREATOR | iSeries: Owner of table or view | |
| 117 | Table/Structure Field |
QSYSKEYCST - TBCREATOR | iSeries: Owner of table or view | |
| 118 | Table/Structure Field |
QSYSKEYCST - TBNAME | iSeries: SQL Name of Table or View | |
| 119 | Table/Structure Field |
QSYSKEYCST - TBNAME | iSeries: SQL Name of Table or View | |
| 120 | Table/Structure Field |
QSYSKEYCST - TDBNAME | iSeries: SQL schema name of table or view | |
| 121 | Table/Structure Field |
QSYSKEYCST - TDBNAME | iSeries: SQL schema name of table or view | |
| 122 | Table/Structure Field |
QSYSKEYS - COLNAME | iSeries: SQL column name | |
| 123 | Table/Structure Field |
QSYSKEYS - COLNAME | iSeries: SQL column name | |
| 124 | Table/Structure Field |
QSYSKEYS - COL_POS | iSeries: Ordinal position of field in the table | |
| 125 | Table/Structure Field |
QSYSKEYS - COL_POS | iSeries: Ordinal position of field in the table | |
| 126 | Table/Structure Field |
QSYSKEYS - COL_SEQ | iSeries: Position of column within the key/index | |
| 127 | Table/Structure Field |
QSYSKEYS - COL_SEQ | iSeries: Position of column within the key/index | |
| 128 | Table/Structure Field |
QSYSKEYS - IDX_NAME | iSeries: SQL index name | |
| 129 | Table/Structure Field |
QSYSKEYS - IDX_NAME | iSeries: SQL index name | |
| 130 | Table/Structure Field |
QSYSKEYS - IDX_SCHEMA | iSeries: SQL schema name of index | |
| 131 | Table/Structure Field |
QSYSKEYS - IDX_SCHEMA | iSeries: SQL schema name of index | |
| 132 | Table/Structure Field |
QSYSKEYS - IXCREATOR | iSeries: Owner of index | |
| 133 | Table/Structure Field |
QSYSKEYS - IXCREATOR | iSeries: Owner of index | |
| 134 | Table/Structure Field |
QSYSKEYS - ORDERING | iSeries: Order of the column in the index | |
| 135 | Table/Structure Field |
QSYSKEYS - ORDERING | iSeries: Order of the column in the index | |
| 136 | Table/Structure Field |
QSYSKEYS - SYS_CNAME | iSeries: iSeries system column name | |
| 137 | Table/Structure Field |
QSYSKEYS - SYS_CNAME | iSeries: iSeries system column name | |
| 138 | Table/Structure Field |
QSYSKEYS - SYS_IDNAME | iSeries: iSeries system index schema name | |
| 139 | Table/Structure Field |
QSYSKEYS - SYS_IDNAME | iSeries: iSeries system index schema name | |
| 140 | Table/Structure Field |
QSYSKEYS - SYS_IXNAME | iSeries: iSeries system index name | |
| 141 | Table/Structure Field |
QSYSKEYS - SYS_IXNAME | iSeries: iSeries system index name | |
| 142 | Table/Structure Field |
QSYSTABLES - ALTEREDTS | iSeries: Timestamp of last change date | |
| 143 | Table/Structure Field |
QSYSTABLES - COLCOUNT | iSeries: Number of columns in table/view/index | |
| 144 | Table/Structure Field |
QSYSTABLES - DBNAME | iSeries: SQL schema name of table or view | |
| 145 | Table/Structure Field |
QSYSTABLES - LABELTEXT | iSeries: Label of a table or view | |
| 146 | Table/Structure Field |
QSYSTABLES - REMARKS | iSeries: Long comment of a table, view or table field | |
| 147 | Table/Structure Field |
QSYSTABLES - ROW_LENGTH | iSeries: Maximum length of any row in table or view | |
| 148 | Table/Structure Field |
QSYSTABLES - SYS_DNAME | iSeries: iSeries system name of table/view schema | |
| 149 | Table/Structure Field |
QSYSTABLES - SYS_TNAME | iSeries: iSeries system name of table or view | |
| 150 | Table/Structure Field |
QSYSTABLES - TBCREATOR | iSeries: Owner of table or view | |
| 151 | Table/Structure Field |
QSYSTABLES - TBNAME | iSeries: SQL Name of Table or View | |
| 152 | Table/Structure Field |
QSYSTABLES - TBTYPE | iSeries: Table type | |
| 153 | Table/Structure Field |
QSYSVIEWDP - SYS_DNAME | iSeries: iSeries system name of table/view schema | |
| 154 | Table/Structure Field |
QSYSVIEWDP - SYS_TNAME | iSeries: iSeries system name of table or view | |
| 155 | Table/Structure Field |
QSYSVIEWDP - SYS_VDNAME | iSeries: iSeries system schema name of view | |
| 156 | Table/Structure Field |
QSYSVIEWDP - SYS_VNAME | iSeries: iSeries system name of view | |
| 157 | Table/Structure Field |
QSYSVIEWDP - TAB_SCHEMA | iSeries: SQL schema name of table or view | |
| 158 | Table/Structure Field |
QSYSVIEWDP - TBCREATOR | iSeries: Owner of table or view | |
| 159 | Table/Structure Field |
QSYSVIEWDP - TBNAME | iSeries: SQL name of the table/view the view is created over | |
| 160 | Table/Structure Field |
QSYSVIEWDP - TBTYPE | iSeries: Table type | |
| 161 | Table/Structure Field |
QSYSVIEWDP - V_CREATOR | iSeries: Owner of table or view | |
| 162 | Table/Structure Field |
QSYSVIEWDP - V_NAME | iSeries: SQL view name | |
| 163 | Table/Structure Field |
QSYSVIEWDP - V_SCHEMA | iSeries: SQL schema name of view | |
| 164 | Table/Structure Field |
QSYSVIEWS - CHECK_OPT | iSeries: Check option used on view | |
| 165 | Table/Structure Field |
QSYSVIEWS - DBNAME | iSeries: SQL schema name of view | |
| 166 | Table/Structure Field |
QSYSVIEWS - SEQ_NO | iSeries: Sequence no. of this row; will allways be 1 | |
| 167 | Table/Structure Field |
QSYSVIEWS - SYS_DNAME | iSeries: iSeries system schema name of view | |
| 168 | Table/Structure Field |
QSYSVIEWS - SYS_TNAME | iSeries: iSeries system name of view | |
| 169 | Table/Structure Field |
QSYSVIEWS - UPDATES | iSeries: View is updatable | |
| 170 | Table/Structure Field |
QSYSVIEWS - VIEW_DEF | iSeries: Part of view definition, if possible | |
| 171 | Table/Structure Field |
QSYSVIEWS - V_CREATOR | iSeries: Owner of table or view | |
| 172 | Table/Structure Field |
QSYSVIEWS - V_NAME | iSeries: SQL view name | |
| 173 | Table/Structure Field |
SYST - SYSID | ABAP System Field: Name of SAP System |
