SAP ABAP Interface IF_RSDRS_SQL_QUERY (SQL Interface)
Hierarchy
☛ SAP_BW (Software Component) SAP Business Warehouse
   ⤷ BW-BEX-OT (Application Component) OLAP Technology
     ⤷ RSDRS (Package) Data Manager 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
Interface IF_RSDRS_SQL_QUERY  
Short Description SQL Interface    
General Data
Package RSDRS   Data Manager SQL Interface 
Created 20051010   SAP 
Last changed 20110908   SAP 
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
Interface IF_RSDRS_SQL_QUERY has no interface.
Friends
Interface IF_RSDRS_SQL_QUERY has no friend.
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
Interface IF_RSDRS_SQL_QUERY has no event.
Types
Interface 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 710