SAP ABAP Function Module STU3_EXPLAIN_SQL (Explains and displays the access path of an SQL statement)
Hierarchy
☛
SAP_BASIS (Software Component) SAP Basis Component
⤷
BC-DB-DB2 (Application Component) DB2 for z/OS
⤷
STU3 (Package) Development Class for Database Monitor
SAP_BASIS (Software Component) SAP Basis Component⤷
BC-DB-DB2 (Application Component) DB2 for z/OS⤷
STU3 (Package) Development Class for Database Monitor
Basic Data
| Function Module | STU3_EXPLAIN_SQL | Explains and displays the access path of an SQL statement |
| Function Group | STU3_EXPLAIN | Functions dealing with SQL EXPLAIN |
| Program Name | SAPLSTU3_EXPLAIN | |
| INCLUDE Name | LSTU3_EXPLAINU01 |
Parameters
| Type | Parameter Name | Typing | Associated Type | Default value | Optional | Pass Value | Short text |
|---|---|---|---|---|---|---|---|
 Exporting |
SQL_CODE | TYPE | I | SQL code of explain statement ID | |||
 Importing |
DB_CONNECTION | TYPE | DBCON-CON_NAME | Logical name for a database connection | |||
| Importing |
NO_DISPLAY | TYPE | C | Single-character flag | |||
| Importing |
EXPLAIN_STMT | TYPE | C | SQL statement text | |||
| Importing |
EXPERT_MODE | TYPE | I | 0 | Display expert mode? | ||
| Importing |
PERFORM_EXPLAIN | TYPE | I | 0 | Perform Explain within function? | ||
| Importing |
STMT_ID | TYPE | I | Statement ID from DSC | |||
| Importing |
STMT_TOKEN | TYPE | C | ||||
| Importing |
CALLED_BY_DBACOCKPIT | TYPE | C | Specifies if this function has been called by the DBACOCKPIT | |||
| Importing |
STMT_DATE | TYPE | DATS | Date for historical view | |||
| Importing |
STMT_TIME | TYPE | TIMS | Time for historical view in UTC | |||
| Importing |
STMT_MSEC | TYPE | DB2EVTTMS | Msec for historical view | |||
 Tables |
PLAN | TYPE | EXPL_PLAN | Access Plan Output Line (FB RS_EXPLAIN_PLAN...) | |||
Processing Type
| Normal Function Module | |
 Remote-Enabled Module |
BaseXML supported |
| Update Module | Start immediately |
| Immediate Start, No Restart | |
| Start Delayed | |
| Coll.run | |
| JAVA Module Callable from ABAP | |
| Remote-Enabled JAVA Module | |
| Module Callable from JAVA |
History
| Last changed by/on | SAP | 20040312 |
| SAP Release Created in | 620 |
