| TBNAME |
iSeries: SQL Name of Table or View |
CHAR |
30 |
0 |
*
|
TBNAME
|
|
| TBCREATOR |
iSeries: Owner of table or view |
CHAR |
10 |
0 |
|
TBCREATOR
|
|
| TBTYPE |
iSeries: Table type |
CHAR |
1 |
0 |
|
TBTYPE
|
|
| COLCOUNT |
iSeries: Number of columns in table/view/index |
INT4 |
10 |
0 |
|
COLCOUNT
|
|
| ROW_LENGTH |
iSeries: Maximum length of any row in table or view |
INT4 |
10 |
0 |
|
ROW_LENGTH
|
|
| LABELTEXT |
iSeries: Label of a table or view |
CHAR |
50 |
0 |
|
TB_LABEL
|
|
| REMARKS |
iSeries: Long comment of a table, view or table field |
CHAR |
255 |
0 |
|
REMARKS
|
|
| DBNAME |
iSeries: SQL schema name of table or view |
CHAR |
10 |
0 |
|
TAB_SCHEMA
|
|
| ALTEREDTS |
iSeries: Timestamp of last change date |
CHAR |
26 |
0 |
|
ALTEREDTS
|
|
| SYS_TNAME |
iSeries: iSeries system name of table or view |
CHAR |
10 |
0 |
|
SYS_TNAME
|
|
| SYS_DNAME |
iSeries: iSeries system name of table/view schema |
CHAR |
10 |
0 |
|
SYS_DNAME
|
|