SAP ABAP Class CL_DB2_SP (DB2 for z/OS: Stored Procedure Class)
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 MonitorProperties
| Class | CL_DB2_SP | |
| Short Description | DB2 for z/OS: Stored Procedure Class | |
| Super Class | ||
| Instantiability of a Class | 2 | Public |
| Final |
General Data
| Message Class | ||
| Program status | ||
| Category | 0 | |
| Package | STU3 | Development Class for Database Monitor |
| Created | 20130320 | SAP |
| Last change | 20140121 | SAP |
| Shared Memory-enabled | ||
| Fixed point arithmetic | ||
| Unicode checks active |
Forward declarations
Class CL_DB2_SP has no forward declaration.
Interfaces
Class CL_DB2_SP has no interface implemented.
Friends
Class CL_DB2_SP has no friend class.
Attributes
| # | Attribute | Level | Visibility | Read only | Typing | Associated Type | Initial Value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | NOT_NULL |
Constant | Public | Type reference (TYPE) | INT2 | 0 | SQL indicator for value "not null" | 20130813 | |
| 2 | NULL |
Constant | Public | Type reference (TYPE) | INT2 | -1 | SQL indicator for value "null" | 20130813 |
Methods
| # | Method | Level | Visibility | Method type | Description | Created on |
|---|---|---|---|---|---|---|
| 1 | CALL_ADMIN_COMMAND_MVS |
Static method | Public | Method | Call DB2 stored procedure ADMIN_COMMAND_MVS | 20130813 |
| 2 | CALL_GET_SYSTEM_INFO |
Static method | Public | Method | Call to SP GET_SYSTEM_INFO | 20130813 |
Events
Class CL_DB2_SP has no event.
Types
Class CL_DB2_SP has no local type.
Method Signatures
Method CALL_ADMIN_COMMAND_MVS Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 |  Exporting |
CMD_OUTPUT | Call by reference | Type reference (TYPE) | DB2_CMD_OUT_TAB | DB2 Command output table | 20130813 | ||
| 2 |  Importing |
CMD_PREFIX | Call by reference | Type reference (TYPE) | STRING | DB2 command prefix | 20130813 | ||
| 3 | Importing |
CMD_TYPE | Call by reference | Type reference (TYPE) | STRING | Command Type e.g. HSM, WLM | 20130813 | ||
| 4 | Importing |
COMMAND | Call by reference | Type reference (TYPE) | STRING | Command to be executed | 20130813 | ||
| 5 | Importing |
EXEC_ON_LPAR | Call by reference | Type reference (TYPE) | STRING | z/OS system to which the DB2 command is to be routed. | 20130813 | ||
| 6 | Importing |
JOBNAME | Call by reference | Type reference (TYPE) | STRING | Batch job or started task to be modified | 20130813 | ||
| 7 | Importing |
PARAMETERS | Call by reference | Type reference (TYPE) | STRING | Parameters of the command, | 20130813 | ||
| 8 | Importing |
REMOTE_DBCON | Call by reference | Type reference (TYPE) | DBCON_NAME | Logical name for a database connection | 20130813 | ||
| 9 | Importing |
SUBPARAMETERS | Call by reference | Type reference (TYPE) | STRING | Ssubparameters of the command | 20130813 | ||
| 10 | Importing |
WAIT_TIMEOUT | Call by reference | Type reference (TYPE) | I | Time procedure waits for the command to complete | 20130813 |
| # | Exception | Resumable | Description | Created on |
|---|---|---|---|---|
| 1 |  CX_DB2_ROOT |
DB2: root class regarding exceptions | 20130813 | |
| 2 | CX_SQL_EXCEPTION |
Exception Class for SQL Error | 20130813 |
Method CALL_GET_SYSTEM_INFO Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Importing |
INPUT_MAJOR_VER | Call by reference | Type reference (TYPE) | INT4 | 1 | Major version of input XML document | 20130813 | |
| 2 | Importing |
INPUT_MINOR_VER | Call by reference | Type reference (TYPE) | INT4 | 1 | Minor version of input XML document | 20130813 | |
| 3 | Importing |
REMOTE_DBCON | Call by reference | Type reference (TYPE) | DBCON_NAME | Connection of monitored System | 20130813 | ||
| 4 | Importing |
XML_FILTER_S | Call by reference | Type reference (TYPE) | STRING | Filter for the XML result set formatted as XPATH query | 20130813 | ||
| 5 | Importing |
XML_INPUT_S | Call by reference | Type reference (TYPE) | STRING | Input XML for SP supplied as String | 20130813 | ||
| 6 | Importing |
XML_INPUT_X | Call by reference | Type reference (TYPE) | XSTRING | Input XML for SP supplied as XString | 20130813 | ||
| 7 | Exporting |
XML_OUTPUT_S | Call by reference | Type reference (TYPE) | STRING | Generated Output XML supplied as String | 20130813 | ||
| 8 | Exporting |
XML_OUTPUT_X | Call by reference | Type reference (TYPE) | XSTRING | Generated Output XML supplied as XString | 20130813 |
| # | Exception | Resumable | Description | Created on |
|---|---|---|---|---|
| 1 | CX_DB2_ROOT |
DB2: root class regarding exceptions | 20130813 | |
| 2 | CX_SQL_EXCEPTION |
Exception Class for SQL Error | 20130813 |
History
| Last changed by/on | SAP | 20140121 |
| SAP Release Created in | 740 |
