SAP ABAP Function Module MSS_GET_SQLEXPLAIN (MS SQL Server get explain for a given SQL statement)
Hierarchy
☛
SAP_BASIS (Software Component) SAP Basis Component
⤷ BC-DB-MSS (Application Component) Microsoft SQL Server
⤷ STUN_MSS (Package) Package for new SQL Server monitoring objects
⤷ BC-DB-MSS (Application Component) Microsoft SQL Server
⤷ STUN_MSS (Package) Package for new SQL Server monitoring objects
Basic Data
Function Module | MSS_GET_SQLEXPLAIN | MS SQL Server get explain for a given SQL statement |
Function Group | SMSSDATA1 | MSS: Cockpit Backend not from RAT |
Program Name | SAPLSMSSDATA1 | |
INCLUDE Name | LSMSSDATA1U69 |
Parameters
Type | Parameter Name | Typing | Associated Type | Default value | Optional | Pass Value | Short text |
---|---|---|---|---|---|---|---|
Importing | CON_NAME | TYPE | DBCON-CON_NAME | 'DEFAULT' | Logical name of a Database Connection | ||
Importing | SCHEMA | TYPE | MSSSCHEMA | SPACE | Target Schema | ||
Importing | SP_NAME | TYPE | MSQOBJECTS-NAME | ' ' | |||
Importing | FINAL_COMMAND | TYPE | MSQEXPLAIN-LONGSQLTXT | ||||
Importing | GURU_AT_WORK | TYPE | MSSHELP-MIRRFLAG | ' ' | |||
Importing | STATIO_X | TYPE | MSQEXPLAIN-IOSTATSON | 'X' | |||
Importing | TIMESTATS_X | TYPE | MSQEXPLAIN-TIMESTATON | 'X' | |||
Importing | SHOWPLAN_X | TYPE | MSQEXPLAIN-SHOWPLANON | 'X' | |||
Importing | NOEXEC_X | TYPE | MSQEXPLAIN-NOEXEC | ' ' | |||
Importing | TRACE_FLAGS | TYPE | MSQEXPLAIN-TRACEFLAGS | ' ' | |||
Tables | SP_PARAMS | TYPE | MSQSPPARAM | ||||
Tables | EXPLAIN_RESULT | TYPE | MSQSTPRTXT | ||||
Tables | STMT_LINES | TYPE | MSQSQLCODE | MS SQL server structure to get the sp text | |||
Exception | DB_ERROR | TYPE | Some database error occurred. | ||||
Exception | INTERNAL_ERROR | TYPE | Internal ADBC error. | ||||
Exception | NOT_RUNNING_ON_MSSQL | TYPE | Not MSSQL | ||||
Exception | CONNECT_ERROR | TYPE | Can't connect | ||||
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 | 20100421 |
SAP Release Created in | 711 |