Table/Structure Field list used by SAP ABAP Function Module GET_TABLE_SIZE_DB4 (AS/400: Get table size w/ or w/o indices)
SAP ABAP Function Module
GET_TABLE_SIZE_DB4 (AS/400: Get table size w/ or w/o indices) is using
| # | Object Type | Object Name | Object Description | Note |
|---|---|---|---|---|
| 1 | DB4INDEX_STAT - INDSIZE | Total blocks of an index (kb) | ||
| 2 | DB4INDEX_STAT - INDTABLE | Table name | ||
| 3 | DB4INDEX_STAT - SCHEMANAME | DB4INDEX_STAT-SCHEMANAME | ||
| 4 | DB4INDEX_STAT - DBHOST | Application Server | ||
| 5 | DB4TABLE_STAT - CSTSIZE | iSeries: Number of rows / object size | ||
| 6 | DB4TABLE_STAT - DBHOST | Application Server | ||
| 7 | DB4TABLE_STAT - SCHEMANAME | DB4TABLE_STAT-SCHEMANAME | ||
| 8 | DB4TABLE_STAT - TABNAME | Table name | ||
| 9 | DB4TABLE_STAT - TABSIZE | Used blocks of a table in KB | ||
| 10 | DB6NAVSYST - DBHOST | DBA Cockpit: Server Name | SOURCE VALUE(DBHOST) LIKE DB6NAVSYST-DBHOST OPTIONAL |
|
| 11 | DB6NAVSYST - SCHEMANAME | DB6: Schema Name | ||
| 12 | DB6NAVSYST - SCHEMANAME | DB6: Schema Name | SOURCE VALUE(SCHEMANAME) LIKE DB6NAVSYST-SCHEMANAME OPTIONAL |
|
| 13 | DB6NAVSYST - DBHOST | DBA Cockpit: Server Name | ||
| 14 | DBSTATC - ACTIV | Control Flag for Update of Statistics | ||
| 15 | DBSTATC - ACTIV | Control Flag for Update of Statistics | SOURCE VALUE(DATA_SPACE_ONLY) LIKE DBSTATC-ACTIV OPTIONAL |
|
| 16 | DBSTATC - ACTIV | Control Flag for Update of Statistics | SOURCE VALUE(TABLE_FRAGMENTED) LIKE DBSTATC-ACTIV |
|
| 17 | DD02L - TABNAME | Table Name | SOURCE VALUE(TABNAME) LIKE DD02L-TABNAME |
|
| 18 | DD02L - TABNAME | Table Name |