Table/Structure Field list used by SAP ABAP Function Module ST04_DB4_GET_SQR_INFO (AS/400: Get SQL Requests/Top50 info for ST04 Detail Analysis)
SAP ABAP Function Module 
ST04_DB4_GET_SQR_INFO (AS/400: Get SQL Requests/Top50 info for ST04 Detail Analysis) is using
-
Class (5)
-
Data Element (5)
-
Table/Structure Field (32)
-
Function Module (1)
-
Message Class (1)
-
Message Number (4)
-
Class Method (8)
-
Table (12)
| # | Object Type | Object Name | Object Description | Note |
|---|---|---|---|---|
 |
|
|||
| 1 | Table/Structure Field |
DB4QQPAR - QRESET | iSeries: Flag to indicate reset in ST04 | SOURCE VALUE(RESETFLAG) LIKE DB4QQPAR-QRESET DEFAULT SPACE |
| 2 | Table/Structure Field |
DB4QQPAR - QRESET | iSeries: Flag to indicate reset in ST04 | |
| 3 | Table/Structure Field |
DB4SQR0100 - QQPLIB | iSeries: Package/Program Library (Database Monitor) | |
| 4 | Table/Structure Field |
DB4SQR0100 - TOTTIME | iSeries: Total Time (Database Monitor) | |
| 5 | Table/Structure Field |
DB4SQR0100 - SYSID | Name of SAP System | |
| 6 | Table/Structure Field |
DB4SQR0100 - QQUSER | iSeries: Job User (Database Monitor) | |
| 7 | Table/Structure Field |
DB4SQR0100 - QQSTTX | iSeries: Statement Text (Database Monitor) | |
| 8 | Table/Structure Field |
DB4SQR0100 - QQSTF | iSeries: Statement Function (Database Monitor) | |
| 9 | Table/Structure Field |
DB4SQR0100 - QQSNAM | iSeries: Statement Name (Database Monitor) | |
| 10 | Table/Structure Field |
DB4SQR0100 - QQPNAM | iSeries: Package/Program Name (Database Monitor) | |
| 11 | Table/Structure Field |
DB4SQR0100 - QQOTHT | iSeries: Any other time (Database Monitor) | |
| 12 | Table/Structure Field |
DB4SQR0100 - QQOPNT | iSeries: Open time (Database Monitor) | |
| 13 | Table/Structure Field |
DB4SQR0100 - QQMINT | iSeries: Minimum Time (Database Monitor) | |
| 14 | Table/Structure Field |
DB4SQR0100 - QQMAXT | iSeries: Maximum Time (Database Monitor) | |
| 15 | Table/Structure Field |
DB4SQR0100 - IPLTIME | Text field length 14 | |
| 16 | Table/Structure Field |
DB4SQR0100 - QQARSS | iSeries: Average Result Set Size (Database Monitor) | |
| 17 | Table/Structure Field |
DB4SQR0100 - QQAVGT | iSeries: Average Time (Database Monitor) | |
| 18 | Table/Structure Field |
DB4SQR0100 - QQCLST | iSeries: CLOSE time (Database Monitor) | |
| 19 | Table/Structure Field |
DB4SQR0100 - QQCNAM | iSeries: Cursor Name (Database Monitor) | |
| 20 | Table/Structure Field |
DB4SQR0100 - QQCNT | iSeries: No. of Executions of a Statement (Database Monitor) | |
| 21 | Table/Structure Field |
DB4SQR0100 - QQFETT | iSeries: FETCH time (Database Monitor) | |
| 22 | Table/Structure Field |
DB4SQR0100 - QQKEY | iSeries: Key Field (Database Monitor) | |
| 23 | Table/Structure Field |
DB4SQR0100 - QQLTU | iSeries: Time Last Used (Database Monitor) | |
| 24 | Table/Structure Field |
DB4SQR0100 - QQMETU | iSeries: Timest. of Most Expensive Stmt. (Database Monitor) | |
| 25 | Table/Structure Field |
DB6NAVSYST - DBCNAME | Logical name for a database connection | |
| 26 | Table/Structure Field |
DBCON - CON_NAME | Logical name for a database connection | |
| 27 | Table/Structure Field |
DD02L - TABNAME | Table Name | SOURCE VALUE(TAB_NAME) LIKE DD02L-TABNAME DEFAULT SPACE |
| 28 | Table/Structure Field |
DD02L - TABNAME | Table Name | |
| 29 | Table/Structure Field |
SQLTABLE_DB4_T - QQKEY | iSeries: Key Field (Database Monitor) | |
| 30 | Table/Structure Field |
SQLTABLE_DB4_T - TABNAME | Table Name | |
| 31 | Table/Structure Field |
SQTEXT_DB4 - QQSTTX_LNG | 2 byte integer (signed) | |
| 32 | Table/Structure Field |
SYST - TABIX | ABAP System Field: Row Index of Internal Tables |
