SAP ABAP Function Module RSDU_EXPLAIN_PLAN_DB2 (Derive and Present Query Processing Plan)
Hierarchy
☛
SAP_BW (Software Component) SAP Business Warehouse
⤷
BW-SYS-DB-DB2 (Application Component) BW DB2 for OS/390
⤷
RSCOREDB2 (Package) BI Core Porting: DB2-z/OS
SAP_BW (Software Component) SAP Business Warehouse⤷
BW-SYS-DB-DB2 (Application Component) BW DB2 for OS/390⤷
RSCOREDB2 (Package) BI Core Porting: DB2-z/OS
Basic Data
| Function Module | RSDU_EXPLAIN_PLAN_DB2 | Derive and Present Query Processing Plan |
| Function Group | RSDU_CORE_UTIL_DB2 | Database-Specific Functions in LEAN |
| Program Name | SAPLRSDU_CORE_UTIL_DB2 | |
| INCLUDE Name | LRSDU_CORE_UTIL_DB2U14 |
Parameters
| Type | Parameter Name | Typing | Associated Type | Default value | Optional | Pass Value | Short text |
|---|---|---|---|---|---|---|---|
 Changing |
C_PROCESSED | TYPE | RS_BOOL | RS_C_FALSE | Boolean | ||
 Exporting |
E_COSTS | TYPE | I | DB-Specific SQL-Error Code (OK = 0) | |||
| Exporting |
E_STMTSIZE | TYPE | I | Size of the SQL Statement in Bytes | |||
 Importing |
I_T_STMT | TYPE | RSDU_T_ABAPSOURCE | SQL Statement in an Internal Table | |||
| Importing |
I_STMT | TYPE | C | SQL Statement in a String | |||
| Importing |
I_SHOW_PLAN | TYPE | RS_BOOL | RS_C_FALSE | Display Execution Plan | ||
 Exception |
EXPLAIN_ERROR | TYPE | Error During EXPLAIN PLAN Call | ||||
| Exception |
STATEMENT_TOO_COMPLEX | TYPE | Statement Is Too Long | ||||
| Exception |
NO_STATEMENT | TYPE | No Statement Specified | ||||
| Exception |
PLAN_TABLE_ERROR | TYPE | Error in PLAN_TABLE (Oracle Only) | ||||
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 | 20110909 |
| SAP Release Created in | 730 |
