SAP ABAP Class IF_RSDRS_SQL_QUERY (SQL Interface)
Meta Relationship - Used By
| # | Relationship type | Used by | Short Description | Created on |
|---|---|---|---|---|
| 1 | Interface implementation (CLASS c. INTERFACES i_ref) | CL_RSDRS_SQL_QUERY | Data Manager SQL Query Processing | 20051010 |
| 2 | Interface implementation (CLASS c. INTERFACES i_ref) | CL_RSDRS_TOP_QUERY | Abstract TOP/BOTTOM Query | 20051010 |
Properties
| Class | IF_RSDRS_SQL_QUERY | |
| Short Description | SQL Interface | |
| Super Class | ||
| Instantiability of a Class | 2 | Public |
| Final |
General Data
| Message Class | ||
| Program status | ||
| Category | 0 | |
| Package | ||
| Created | 20051010 | SAP |
| Last change | 20110908 | SAP |
| Shared Memory-enabled | ||
| Fixed point arithmetic | ||
| Unicode checks active |
Forward declarations
| # | Type group / Object type | Type | Type Description |
|---|---|---|---|
| 1 |  RSD |
Type group use (TYPE-POOLS tp) | Type group use (TYPE-POOLS tp) |
| 2 | RSDRS |
Type group use (TYPE-POOLS tp) | Type group use (TYPE-POOLS tp) |
Interfaces
Class IF_RSDRS_SQL_QUERY has no interface implemented.
Friends
Class IF_RSDRS_SQL_QUERY has no friend class.
Attributes
| # | Attribute | Level | Visibility | Read only | Typing | Associated Type | Initial Value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | N_SX_QUERY |
Instance attribute | Public | Type reference (TYPE) | RSDRS_SX_QUERY | 20051010 |
Methods
| # | Method | Level | Visibility | Method type | Description | Created on |
|---|---|---|---|---|---|---|
| 1 | CLEANUP |
Instance method | Public | Method | cleanup after execution, not needed with read_data | 20051010 |
| 2 | DELETE |
Instance method | Public | Method | Delete from DB table | 20051010 |
| 3 | GET_CODE |
Instance method | Public | Method | get the generated statement | 20051010 |
| 4 | MATERIALIZE |
Instance method | Public | Method | Materialize query result within DB table | 20051010 |
| 5 | READ_DATA |
Instance method | Public | Method | execute the query and return the data read | 20051010 |
| 6 | SIMULATE |
Instance method | Public | Method | show access plan for a query | 20051010 |
Events
Class IF_RSDRS_SQL_QUERY has no event.
Types
Class IF_RSDRS_SQL_QUERY has no local type.
Method Signatures
Method CLEANUP Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 |  Importing |
I_CONNECTION | Value transfer | Type reference (TYPE) | DBCON_NAME | 'R/3*' | Logischer Name einer Datenbankverbindung | 20070404 |
| # | Exception | Resumable | Description | Created on |
|---|---|---|---|---|
| 1 |  CX_SY_SQL_ERROR |
SQL error | 20051010 |
Method DELETE Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Importing |
I_ENH_DB_OPT | Call by reference | Type reference (TYPE) | RS_BOOL | RS_C_TRUE | allow using enhanced db options | 20051010 | |
| 2 | Importing |
I_ROLLBACK_IF_ERROR | Call by reference | Type reference (TYPE) | RS_BOOL | RS_C_FALSE | Rollback database transaction, if error occurs | 20051010 | |
| 3 | Importing |
I_SHOW_STATEMENT | Call by reference | Type reference (TYPE) | RS_BOOL | RS_C_FALSE | Show generated SQL Statement | 20051010 | |
| 4 |  Returning |
R_CNT | Value transfer | Type reference (TYPE) | I | number of records deleted | 20051010 |
| # | Exception | Resumable | Description | Created on |
|---|---|---|---|---|
| 1 | CX_RSDRS_STMT_TOO_LONG |
Generated Stmt is too long ... | 20051010 | |
| 2 | CX_RSDRS_TABLE_DOES_NOT_EXIST |
Table does not exist | 20051010 | |
| 3 | CX_SY_SQL_ERROR |
SQL error | 20051010 |
Method GET_CODE Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 |  Exporting |
E_T_CODE | Call by reference | Type reference (TYPE) | RSDRS_T_ABAPSOURCE | Generated Code | 20051010 | ||
| 2 | Importing |
I_SHOW_STATEMENT | Call by reference | Type reference (TYPE) | RS_BOOL | RS_C_FALSE | Show the generated statement | 20051010 |
| # | Exception | Resumable | Description | Created on |
|---|---|---|---|---|
| 1 | CX_RSDRS_STMT_TOO_LONG |
SQL Statement Is Too Large | 20051010 |
Method MATERIALIZE Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Importing |
I_ANALYZE_TABLE | Value transfer | Type reference (TYPE) | RS_BOOL | RS_C_TRUE | Generate DB Optimizer Statistics | 20051010 | |
| 2 | Importing |
I_ENH_DB_OPT | Value transfer | Type reference (TYPE) | RS_BOOL | RS_C_TRUE | allow using enhanced db options | 20051010 | |
| 3 | Importing |
I_ROLLBACK_IF_ERROR | Value transfer | Type reference (TYPE) | RS_BOOL | RS_C_FALSE | Rollback database transaction, if error occurs | 20051010 | |
| 4 | Importing |
I_SHOW_STATEMENT | Value transfer | Type reference (TYPE) | RS_BOOL | RS_C_FALSE | Show generated SQL Statement | 20051010 | |
| 5 | Returning |
R_COUNTER | Value transfer | Type reference (TYPE) | I | Compression counter | 20060925 |
| # | Exception | Resumable | Description | Created on |
|---|---|---|---|---|
| 1 | CX_RSDRS_STMT_TOO_LONG |
SQL Statement Is Too Large | 20051010 | |
| 2 | CX_RSDRS_TABLE_DOES_NOT_EXIST |
Table does not exist | 20051010 | |
| 3 | CX_RSDRS_TABLE_EXISTS_ALREADY |
Table Already Exists | 20051010 | |
| 4 | CX_RSDR_CUBE_LOCKED |
Cube is locked (due to compression, ...) | 20051013 | |
| 5 | CX_SY_SQL_ERROR |
SQL error | 20051010 |
Method READ_DATA Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Exporting |
E_COUNTER | Call by reference | Type reference (TYPE) | I | Compression counter for infocubes | 20051010 | ||
| 2 | Exporting |
E_EOF | Value transfer | Type reference (TYPE) | RS_BOOL | end of data reached | 20051010 | ||
| 3 | Exporting |
E_T_DATA | Call by reference | Type reference (TYPE) | STANDARD TABLE | result data | 20051010 | ||
| 4 | Importing |
I_ALLOW_ADBC | Value transfer | Type reference (TYPE) | RS_BOOL | allow usage of ADBC | 20051010 | ||
| 5 | Importing |
I_CUBE | Value transfer | Type reference (TYPE) | RSD_INFOCUBE | 20060614 | |||
| 6 | Importing |
I_ENH_DB_OPT | Value transfer | Type reference (TYPE) | RS_BOOL | RS_C_TRUE | allow using enhanced db options | 20051010 | |
| 7 | Importing |
I_PKGSIZE | Value transfer | Type reference (TYPE) | I | 1000 | 20051010 | ||
| 8 | Importing |
I_SHOW_REPORT | Value transfer | Type reference (TYPE) | RS_BOOL | RS_C_FALSE | display generated stmt/report | 20051010 | |
| 9 | Importing |
I_TC_BREAK | Value transfer | Type reference (TYPE) | RS_BOOL | RS_C_TRUE | allow testcase break | 20051010 | |
| 10 | Importing |
I_WITH_HOLD | Value transfer | Type reference (TYPE) | RS_BOOL | RS_C_TRUE | Open Cursor with hold | 20051010 |
| # | Exception | Resumable | Description | Created on |
|---|---|---|---|---|
| 1 | CX_RSDRS_STMT_TOO_LONG |
SQL Statement Is Too Large | 20051010 | |
| 2 | CX_RSDR_CUBE_LOCKED |
During Statement Execution compression, ... running | 20051010 | |
| 3 | CX_SY_SQL_ERROR |
SQL error | 20051010 |
Method SIMULATE Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Exporting |
E_COSTS | Call by reference | Type reference (TYPE) | I | Estimated database Costs | 20051010 | ||
| 2 | Importing |
I_ENH_DB_OPT | Value transfer | Type reference (TYPE) | RS_BOOL | RS_C_TRUE | Uses enhanced database features | 20051010 | |
| 3 | Importing |
I_QUERY_SCENARIO | Value transfer | Type reference (TYPE) | RS_BOOL | RS_C_FALSE | Get Query scenario | 20051010 | |
| 4 | Importing |
I_SHOW_PLAN | Value transfer | Type reference (TYPE) | RS_BOOL | RS_C_TRUE | Show access plan | 20051010 | |
| 5 | Importing |
I_SHOW_STATEMENT | Value transfer | Type reference (TYPE) | RS_BOOL | RS_C_FALSE | Show generated SQL statement | 20051010 |
| # | Exception | Resumable | Description | Created on |
|---|---|---|---|---|
| 1 | CX_RSDRS_STMT_TOO_LONG |
SQL Statement Is Too Large | 20051010 |
History
| Last changed by/on | SAP | 20110908 |
| SAP Release Created in |
