SAP Tabel DB2CATTAB (Info on Tables from DB2 Catalog Table SYSIBM.SYSTABLES)
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| NAME | DB2 table name | CHAR | 18 | 0 | DB2TABNAME | ||||||||||
| CREATOR | DB2 creator name | CHAR | 8 | 0 | DB2CREATOR | ||||||||||
| TYPE | Type of DB2 table | CHAR | 1 | 0 | DB2TABTYP |
|
|||||||||
| DBNAME | Database name | CHAR | 8 | 0 | DB2DBNAME | ||||||||||
| TSNAME | Name of the tablespace | CHAR | 8 | 0 | DB2TSNAME | ||||||||||
| RECLENGTH | Maximum length (in bytes) of any record in the table | INT4 | 10 | 0 | DB2RECLEN | ||||||||||
| CARDF | Total number of rows in the table | FLTP | 16 | 16 | DB2CARDF |