SAP ABAP Function Module MSS_MON_SQLTEXT (Get SQL Text for an MSS object)
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
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
Basic Data
| Function Module | MSS_MON_SQLTEXT | Get SQL Text for an MSS object |
| Function Group | SMSSDATA1 | MSS: Cockpit Backend not from RAT |
| Program Name | SAPLSMSSDATA1 | |
| INCLUDE Name | LSMSSDATA1U08 |
Parameters
| Type | Parameter Name | Typing | Associated Type | Default value | Optional | Pass Value | Short text |
|---|---|---|---|---|---|---|---|
 Exporting |
SQLSTRING | TYPE | MSSSQLTEXT | SQL definition statement text | |||
| Exporting |
SQLSTRING_LENGTH | TYPE | INT4 | Length of the SQL definition statement text | |||
 Importing |
CON_NAME | TYPE | DBCON-CON_NAME | 'DEFAULT' | Logical name of a Database Connection | ||
| Importing |
SCHEMA | TYPE | MSSSCHEMA | SPACE | Target Schema | ||
| Importing |
OBJ_DB | TYPE | MSSDB | Database where object is located | |||
| Importing |
OBJ_SCHEMA | TYPE | MSSSCHEMA | SPACE | Schema where object is located | ||
| Importing |
OBJECT_NAME | TYPE | MSSOBJECT | Object name | |||
| Importing |
STRING | TYPE | CHAR1 | If 'X', then output as string. | |||
| Importing |
QUOTES | TYPE | CHAR1 | If 'X', then quotes around identifiers are not removed from the output string. | |||
| Importing |
TABLE | TYPE | CHAR1 | If 'X', then output as table. | |||
 Tables |
SQLTABLE | TYPE | MSSSQLSTMT | SQL definition statement text | |||
 Exception |
NOT_RUNNING_ON_MSSQL | TYPE | |||||
| Exception |
DB_ERROR | TYPE | |||||
| Exception |
INTERNAL_ERROR | TYPE | |||||
| Exception |
DB_NOT_FOUND | TYPE | |||||
| Exception |
NO_DB_ACCESS | TYPE | |||||
| Exception |
INVALID_INPUT | TYPE | |||||
| Exception |
SQLTEXT_NOT_FOUND | TYPE | |||||
| Exception |
CONNECT_ERROR | TYPE | |||||
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 |
