SAP ABAP Class CL_RSDB2A_SQL (DB2 Accelerator: ADBC functions)
Hierarchy
☛
SAP_BW (Software Component) SAP Business Warehouse
⤷
BW-SYS-DB-DB2 (Application Component) BW DB2 for OS/390
⤷
RSDB2A (Package) IBM DB2 Analytics Accelerator suppport
SAP_BW (Software Component) SAP Business Warehouse⤷
BW-SYS-DB-DB2 (Application Component) BW DB2 for OS/390⤷
RSDB2A (Package) IBM DB2 Analytics Accelerator suppportProperties
| Class | CL_RSDB2A_SQL | |
| Short Description | DB2 Accelerator: ADBC functions | |
| Super Class | ||
| Instantiability of a Class | 2 | Public |
| Final |
General Data
| Message Class | RS_DB_DB2 | |
| Program status | ||
| Category | 0 | |
| Package | RSDB2A | IBM DB2 Analytics Accelerator suppport |
| Created | 20120731 | SAP |
| Last change | 20140121 | SAP |
| Shared Memory-enabled | ||
| Fixed point arithmetic | ||
| Unicode checks active |
Forward declarations
| # | Type group / Object type | Type | Type Description |
|---|---|---|---|
| 1 |  CL_RSDB2A |
Forward declaration class (CLASS c DEFINITION DEFERRED) | Forward declaration class (CLASS c DEFINITION DEFERRED) |
| 2 | IF_RSDAI_NEARLINE_CONNECTION |
Forward declaration interface (INTERFACE i DEFINITION DEF... | Forward declaration interface (INTERFACE i DEFINITION DEF... |
| 3 | RS |
Type group use (TYPE-POOLS tp) | Type group use (TYPE-POOLS tp) |
Interfaces
Class CL_RSDB2A_SQL has no interface implemented.
Friends
Class CL_RSDB2A_SQL has no friend class.
Attributes
| # | Attribute | Level | Visibility | Read only | Typing | Associated Type | Initial Value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | COMMAND |
Static Attribute | Public | Type reference (TYPE) | RSDB2A_CHAR128 | DB2 Accelerator: Character string length 128 | 20130322 | ||
| 2 | CREATOR |
Static Attribute | Public | Type reference (TYPE) | DB2CREATOR | DB2 creator name | 20120731 | ||
| 3 | C_KEY_RANDOM |
Constant | Public | Type reference (TYPE) | CHAR8 | '#random#' | Character field, 8 characters long | 20130726 | |
| 4 | C_PARAMETER_ACCELERATORNAME |
Constant | Public | Type reference (TYPE) | RSADMIN-OBJECT | 'DB2_ACCELERATORNAME' | Object Administration Business Information Warehouse | 20120731 | |
| 5 | C_SEPARATOR |
Constant | Public | Type reference (TYPE) | CHAR2 | '&&' | Version Number Component | 20130726 | |
| 6 | FROMTIME |
Static Attribute | Public | Type reference (TYPE) | RSDB2A_CHAR19 | DB2 Accelerator: Character string length 19 | 20120731 | ||
| 7 | PARTITIONS |
Static Attribute | Public | Type reference (TYPE) | RSDB2A_CHAR128 | DB2 Accelerator: Character string length 128 | 20120731 | ||
| 8 | TABLE |
Static Attribute | Public | Type reference (TYPE) | DB2TABNAME | DB2 table name | 20120731 | ||
| 9 | TOTIME |
Static Attribute | Public | Type reference (TYPE) | RSDB2A_CHAR19 | DB2 Accelerator: Character string length 19 | 20120731 | ||
| 10 | T_DISTR_KEY |
Static Attribute | Public | Type reference (TYPE) | TY_T_STRING | 20130726 | |||
| 11 | T_ORGAN_KEY |
Static Attribute | Public | Type reference (TYPE) | TY_T_STRING | 20130726 | |||
| 12 | T_TABLE |
Static Attribute | Public | Type reference (TYPE) | RSDB2A_T_TABLE | DB2 Accelerator: list of tables | 20120731 |
Methods
| # | Method | Level | Visibility | Method type | Description | Created on |
|---|---|---|---|---|---|---|
| 1 | COMMIT |
Static method | Public | Method | commit | 20120731 |
| 2 | CORRECT_TABLE_STRUCTURE |
Static method | Public | Method | re-adds tables to DB2 Accelerator with structure changes | 20130726 |
| 3 | EXECUTE_ACCEL_PROCEDURE |
Static method | Public | Method | Runs a DB2 Accelerator stored procedure | 20120731 |
| 4 | EXECUTE_STATEMENT |
Static method | Public | Method | executes an SQL statetment | 20120731 |
| 5 | GENERATE_XML |
Static method | Private | Method | generates an XML document | 20120731 |
| 6 | GET_KEYS |
Static method | Public | Method | returns current and default distribution / organizing keys | 20130726 |
| 7 | PARSE_XML |
Static method | Public | Method | parses an XML document | 20120731 |
| 8 | RAISE_SQL_EXCEPTION |
Static method | Private | Method | raises an sql exception | 20120731 |
| 9 | ROLLBACK |
Static method | Public | Method | rollback | 20120731 |
| 10 | SELECT_SINGLE |
Static method | Public | Method | performs a single record SQL query | 20120731 |
| 11 | SELECT_STRUCT |
Static method | Public | Method | performs a single record SQL query | 20120731 |
| 12 | SELECT_TABLE |
Static method | Public | Method | performs a multi record SQL query | 20120731 |
| 13 | SET_CREATOR |
Static method | Private | Method | sets the SAP schema, i.e. SAPR3 | 20120731 |
| 14 | SET_KEYS |
Static method | Public | Method | sets the default distribution keys | 20130726 |
| 15 | XML_TEMPLATES |
Static method | Private | Method | templates for XML documents | 20120731 |
| 16 | XML_TO_TABLE |
Static method | Public | Method | converts an XML document to an internal table | 20120731 |
Events
Class CL_RSDB2A_SQL has no event.
Types
| # | Type | Visibility | Typing | Associated Type | Description | Created on | Type Source |
|---|---|---|---|---|---|---|---|
| 1 | TY_S_KEY | Public | See coding | 20130726 | begin of TY_S_KEY,
TABNAME type RSDB2A_TABNAME,
ACCELERATED type RSDB2A_FLAG,
DISTR type RSDB2A_CHAR128,
ORGAN type RSDB2A_CHAR128,
DISTR_DEFAULT type RSDB2A_CHAR128,
ORGAN_DEFAULT type RSDB2A_CHAR128,
end of TY_S_KEY
|
||
| 2 | TY_S_XMLELEM | Public | See coding | 20120911 | begin of TY_S_XMLELEM,
ID type i,
PARENT_ID type i,
ELEMENT(32) type c,
PROPERTY(32) type c,
VALUE(32) type c,
TEXT type string,
DEPTH type i,
end of TY_S_XMLELEM
|
||
| 3 | TY_T_KEY | Public | See coding | 20130726 | TY_T_KEY type standard table of TY_S_KEY
|
||
| 4 | TY_T_STRING | Public | See coding | 20130726 | TY_T_STRING type standard table of string
|
||
| 5 | TY_T_XMLELEM | Public | See coding | 20120911 | TY_T_XMLELEM type standard table of TY_S_XMLELEM
|
||
| 6 | TY_XML | Public | See coding | 20120911 | TY_XML(32000) type c
|
Method Signatures
Method COMMIT Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 |  Importing |
I_R_CONNECTION | Call by reference | Object reference (TYPE REF TO) | CL_SQL_CONNECTION | Database Connection | 20120731 |
| # | Exception | Resumable | Description | Created on |
|---|---|---|---|---|
| 1 |  CX_RSDB2A_EXCEPTION |
DB2 Accelerator: exception class | 20120731 |
Method CORRECT_TABLE_STRUCTURE Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 |  Changing |
C_T_MSG | Call by reference | Type reference (TYPE) | RSDB2A_T_MSG | DB2 Accelerator: Table with messages for application log | 20130726 | ||
| 2 | Importing |
I_LOG_HANDLE | Call by reference | Type reference (TYPE) | BALLOGHNDL | Application Log: Log Handle | 20130726 | ||
| 3 | Importing |
I_S_ACCELERATOR | Call by reference | Type reference (TYPE) | RSDB2A_ACCELPROP | DB2 Accelerator: Accelerator properties | 20130726 | ||
| 4 | Importing |
I_T_TABTYPE | Call by reference | Type reference (TYPE) | RSDB2A_T_TABTYPE | DB2 Accelerator: list of table names and replication types | 20130726 |
| # | Exception | Resumable | Description | Created on |
|---|---|---|---|---|
| 1 | CX_RSDB2A_EXCEPTION |
DB2 Accelerator: exception class | 20130726 |
Method EXECUTE_ACCEL_PROCEDURE Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Changing |
C_T_MSG | Call by reference | Type reference (TYPE) | RSDB2A_T_MSG | DB2 Accelerator: Table with messages for application log | 20121024 | ||
| 2 |  Exporting |
E_XML_MSG | Call by reference | Type reference (TYPE) | RSDB2A_XML | DB2 Accelerator: XML document | 20120911 | ||
| 3 | Importing |
I_IGNORE_MSG | Value transfer | Type reference (TYPE) | CHAR1 | Single-Character Flag | 20120731 | ||
| 4 | Importing |
I_LOG_HANDLE | Call by reference | Type reference (TYPE) | BALLOGHNDL | Application Log: Log Handle | 20120731 | ||
| 5 | Importing |
I_PARAM | Call by reference | Type reference (TYPE) | STRING | 20120731 | |||
| 6 | Importing |
I_R_CONNECTION | Call by reference | Object reference (TYPE REF TO) | CL_SQL_CONNECTION | Database Connection | 20120731 | ||
| 7 | Importing |
I_STORED_PROC | Call by reference | Type reference (TYPE) | CHAR255 | Char255 | 20120731 | ||
| 8 | Importing |
I_S_ACCELERATOR | Call by reference | Type reference (TYPE) | RSDB2A_ACCELPROP | DB2 Accelerator: Accelerator properties | 20130322 | ||
| 9 | Exporting |
OUT_PARAM1 | Call by reference | Type reference (TYPE) | ANY | 20120731 | |||
| 10 | Exporting |
OUT_PARAM2 | Call by reference | Type reference (TYPE) | ANY | 20120731 |
| # | Exception | Resumable | Description | Created on |
|---|---|---|---|---|
| 1 | CX_RSDB2A_EXCEPTION |
DB2 Accelerator: exception class | 20120731 |
Method EXECUTE_STATEMENT Signature
| # | Exception | Resumable | Description | Created on |
|---|---|---|---|---|
| 1 | CX_RSDB2A_EXCEPTION |
DB2 Accelerator: exception class | 20120731 |
Method GENERATE_XML Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 |  Returning |
E_XML | Value transfer | Type reference (TYPE) | RSDB2A_XML | DB2 Accelerator: XML document | 20120731 | ||
| 2 | Importing |
I_SCHEMA | Call by reference | Type reference (TYPE) | STRING | 20120731 |
| # | Exception | Resumable | Description | Created on |
|---|---|---|---|---|
| 1 | CX_RSDB2A_EXCEPTION |
DB2 Accelerator: exception class | 20120731 |
Method GET_KEYS Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Exporting |
E_T_KEY | Call by reference | Type reference (TYPE) | TY_T_KEY | 20130726 | |||
| 2 | Importing |
I_CURRENT_VALUES | Value transfer | Type reference (TYPE) | RSDB2A_FLAG | CL_RSDB2A=>TRUE | DB2 Accelerator: Flag | 20130726 | |
| 3 | Importing |
I_DEFAULT_VALUES | Value transfer | Type reference (TYPE) | RSDB2A_FLAG | CL_RSDB2A=>TRUE | DB2 Accelerator: Flag | 20130726 | |
| 4 | Importing |
I_DROP_NOTEXISTS | Value transfer | Type reference (TYPE) | RSDB2A_FLAG | CL_RSDB2A=>FALSE | DB2 Accelerator: Flag | 20130726 | |
| 5 | Importing |
I_LOG_HANDLE | Call by reference | Type reference (TYPE) | BALLOGHNDL | Application Log: Log Handle | 20130726 | ||
| 6 | Importing |
I_S_ACCELERATOR | Call by reference | Type reference (TYPE) | RSDB2A_ACCELPROP | DB2 Accelerator: Accelerator properties | 20130726 | ||
| 7 | Importing |
I_T_TABLE | Call by reference | Type reference (TYPE) | RSDB2A_T_TABLE | DB2 Accelerator: list of tables | 20130726 |
| # | Exception | Resumable | Description | Created on |
|---|---|---|---|---|
| 1 | CX_RSDB2A_EXCEPTION |
DB2 Accelerator: exception class | 20130726 |
Method PARSE_XML Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Exporting |
E_T_XMLELEM | Call by reference | Type reference (TYPE) | TY_T_XMLELEM | DB2 Accelerator: liste of XML elements | 20120731 | ||
| 2 | Importing |
I_XML | Call by reference | Type reference (TYPE) | STRING | DB2 Accelerator: XML document | 20120731 |
| # | Exception | Resumable | Description | Created on |
|---|---|---|---|---|
| 1 | CX_RSDB2A_EXCEPTION |
DB2 Accelerator: exception class | 20120731 |
Method RAISE_SQL_EXCEPTION Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Importing |
I_LOG_HANDLE | Call by reference | Type reference (TYPE) | BALLOGHNDL | Log | 20120731 | ||
| 2 | Importing |
I_R_EXCEPTION | Call by reference | Object reference (TYPE REF TO) | CX_SQL_EXCEPTION | Exception Class for SQL Error | 20120731 |
| # | Exception | Resumable | Description | Created on |
|---|---|---|---|---|
| 1 | CX_RSDB2A_EXCEPTION |
DB2 Accelerator: exception class | 20120731 |
Method ROLLBACK Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Importing |
I_R_CONNECTION | Call by reference | Object reference (TYPE REF TO) | CL_SQL_CONNECTION | Database Connection | 20120731 |
| # | Exception | Resumable | Description | Created on |
|---|---|---|---|---|
| 1 | CX_RSDB2A_EXCEPTION |
DB2 Accelerator: exception class | 20120731 |
Method SELECT_SINGLE Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Returning |
E_DBCOUNT | Value transfer | Type reference (TYPE) | I | 20120731 | |||
| 2 | Importing |
I_LOG_HANDLE | Call by reference | Type reference (TYPE) | BALLOGHNDL | Application Log: Log Handle | 20120731 | ||
| 3 | Importing |
I_R_CONNECTION | Call by reference | Object reference (TYPE REF TO) | CL_SQL_CONNECTION | Database Connection | 20120731 | ||
| 4 | Importing |
I_R_FIELD1 | Call by reference | Object reference (TYPE REF TO) | DATA | 20120731 | |||
| 5 | Importing |
I_R_FIELD2 | Call by reference | Object reference (TYPE REF TO) | DATA | 20120731 | |||
| 6 | Importing |
I_R_PARAM1 | Call by reference | Object reference (TYPE REF TO) | DATA | 20120731 | |||
| 7 | Importing |
I_R_PARAM2 | Call by reference | Object reference (TYPE REF TO) | DATA | 20120731 | |||
| 8 | Importing |
I_R_PARAM3 | Call by reference | Object reference (TYPE REF TO) | DATA | 20120731 | |||
| 9 | Importing |
I_SQLSTMT | Call by reference | Type reference (TYPE) | STRING | 20120731 |
| # | Exception | Resumable | Description | Created on |
|---|---|---|---|---|
| 1 | CX_RSDB2A_EXCEPTION |
DB2 Accelerator: exception class | 20120731 |
Method SELECT_STRUCT Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Returning |
E_DBCOUNT | Value transfer | Type reference (TYPE) | I | 20120731 | |||
| 2 | Importing |
I_LOG_HANDLE | Call by reference | Type reference (TYPE) | BALLOGHNDL | Application Log: Log Handle | 20120731 | ||
| 3 | Importing |
I_R_CONNECTION | Call by reference | Object reference (TYPE REF TO) | CL_SQL_CONNECTION | Database Connection | 20120731 | ||
| 4 | Importing |
I_R_PARAM1 | Call by reference | Object reference (TYPE REF TO) | DATA | 20120731 | |||
| 5 | Importing |
I_R_PARAM2 | Call by reference | Object reference (TYPE REF TO) | DATA | 20120731 | |||
| 6 | Importing |
I_R_PARAM3 | Call by reference | Object reference (TYPE REF TO) | DATA | 20120731 | |||
| 7 | Importing |
I_R_STRUCT | Call by reference | Object reference (TYPE REF TO) | DATA | 20120731 | |||
| 8 | Importing |
I_SQLSTMT | Call by reference | Type reference (TYPE) | STRING | 20120731 |
| # | Exception | Resumable | Description | Created on |
|---|---|---|---|---|
| 1 | CX_RSDB2A_EXCEPTION |
DB2 Accelerator: exception class | 20120731 |
Method SELECT_TABLE Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Returning |
E_DBCOUNT | Value transfer | Type reference (TYPE) | I | 20120731 | |||
| 2 | Importing |
I_IGNORE_SQLCODE | Call by reference | Type reference (TYPE) | I | 20120731 | |||
| 3 | Importing |
I_LOG_HANDLE | Call by reference | Type reference (TYPE) | BALLOGHNDL | Log | 20120731 | ||
| 4 | Importing |
I_R_CONNECTION | Call by reference | Object reference (TYPE REF TO) | CL_SQL_CONNECTION | Database Connection | 20120731 | ||
| 5 | Importing |
I_R_PARAM1 | Call by reference | Object reference (TYPE REF TO) | DATA | 20120731 | |||
| 6 | Importing |
I_R_PARAM2 | Call by reference | Object reference (TYPE REF TO) | DATA | 20120731 | |||
| 7 | Importing |
I_R_PARAM3 | Call by reference | Object reference (TYPE REF TO) | DATA | 20120731 | |||
| 8 | Importing |
I_R_PARAM4 | Call by reference | Object reference (TYPE REF TO) | DATA | 20120731 | |||
| 9 | Importing |
I_R_RESULTTAB | Call by reference | Object reference (TYPE REF TO) | DATA | 20120731 | |||
| 10 | Importing |
I_SQLSTMT | Call by reference | Type reference (TYPE) | STRING | 20120731 |
| # | Exception | Resumable | Description | Created on |
|---|---|---|---|---|
| 1 | CX_RSDB2A_EXCEPTION |
DB2 Accelerator: exception class | 20120731 |
Method SET_CREATOR Signature
Method SET_CREATOR on class CL_RSDB2A_SQL has no parameter.
| # | Exception | Resumable | Description | Created on |
|---|---|---|---|---|
| 1 | CX_RSDB2A_EXCEPTION |
DB2 Accelerator: exception class | 20120731 |
Method SET_KEYS Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Importing |
I_DROP_CORRECT | Value transfer | Type reference (TYPE) | RSDB2A_FLAG | DB2 Accelerator: Flag | 20130726 | ||
| 2 | Importing |
I_FORCE | Value transfer | Type reference (TYPE) | RSDB2A_FLAG | DB2 Accelerator: Flag | 20130726 | ||
| 3 | Importing |
I_LOG_HANDLE | Call by reference | Type reference (TYPE) | BALLOGHNDL | Application Log: Log Handle | 20130726 | ||
| 4 | Importing |
I_S_ACCELERATOR | Call by reference | Type reference (TYPE) | RSDB2A_ACCELPROP | DB2 Accelerator: Accelerator properties | 20130726 | ||
| 5 | Importing |
I_T_KEY | Call by reference | Type reference (TYPE) | TY_T_KEY | 20130726 | |||
| 6 | Importing |
I_T_TABLE | Call by reference | Type reference (TYPE) | RSDB2A_T_TABLE | DB2 Accelerator: list of tables | 20130726 |
| # | Exception | Resumable | Description | Created on |
|---|---|---|---|---|
| 1 | CX_RSDB2A_EXCEPTION |
DB2 Accelerator: exception class | 20130726 |
Method XML_TEMPLATES Signature
Method XML_TEMPLATES on class CL_RSDB2A_SQL has no parameter.
Method XML_TEMPLATES on class CL_RSDB2A_SQL has no exception.
Method XML_TO_TABLE Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Exporting |
E_T_TAB | Call by reference | Type reference (TYPE) | STANDARD TABLE | 20120731 | |||
| 2 | Importing |
I_ELEMENT | Call by reference | Type reference (TYPE) | RSDB2A_CHARVAL | DB2 Accelerator: property value read from xml | 20120731 | ||
| 3 | Importing |
I_ELEMENT_PREFIX | Call by reference | Type reference (TYPE) | RSDB2A_FLAG | CL_RSDB2A=>FALSE | DB2 Accelerator: Flag | 20130726 | |
| 4 | Importing |
I_XML | Call by reference | Type reference (TYPE) | STRING | DB2 Accelerator: XML document | 20120731 |
| # | Exception | Resumable | Description | Created on |
|---|---|---|---|---|
| 1 | CX_RSDB2A_EXCEPTION |
DB2 Accelerator: exception class | 20120914 |
History
| Last changed by/on | SAP | 20140121 |
| SAP Release Created in | 740 |
