SAP ABAP Interface IF_TREX_SQL (ADBC based SQL interface)
Hierarchy
☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-TRX-API (Application Component) TREX ABAP + JAVA API
     ⤷ STREX (Package) TREX ABAP client
Meta Relationship - Used By
# Relationship type Used by Short Description Created on
1 Interface implementation (CLASS c. INTERFACES i_ref)  CL_TREX_SQL_PREPARED_STATEMENT TREX SQL prepared statement. 20100325
2 Interface implementation (CLASS c. INTERFACES i_ref)  CL_TREX_SQL_STATEMENT TREX SQL statement 20100325
Properties
Interface IF_TREX_SQL  
Short Description ADBC based SQL interface    
General Data
Package STREX   TREX ABAP client 
Created 20100325   SAP 
Last changed 20140121   SAP 
Unicode checks active    
Forward declarations
# Type group / Object type Type Type Description
1 ADBC Type group use (TYPE-POOLS tp)  Type group use (TYPE-POOLS tp)
Interfaces
Interface IF_TREX_SQL has no interface.
Friends
Interface IF_TREX_SQL has no friend.
Attributes
# Attribute Level Visibility Read only Typing Associated Type Initial Value Description Created on
1 C_PERF_ID_COMMIT Constant Public Type reference (TYPE) STRING 'COMMIT' 20101104
2 C_SQL_CODE_SYNTAX_ERROR Constant Public Type reference (TYPE) INT4 257 Natural number 20110118
Methods
# Method Level Visibility Method type Description Created on
1 CALL_WITH_XSTRING Instance method Public Method 20100325
2 CLEAR_PARAMETERS Instance method Public Method Only for prepare statement. 20100325
3 CLOSE Instance method Public Method Only for prepare statement. 20100325
4 EXECUTE_DDL Instance method Public Method 20100326
5 EXECUTE_PROCEDURE Instance method Public Method 20110513
6 EXECUTE_QUERY_COUNT_ONLY Instance method Public Method 20100325
7 EXECUTE_QUERY_ITAB Instance method Public Method 20100325
8 EXECUTE_QUERY_SINGLE_FIELD Instance method Public Method 20130424
9 EXECUTE_UPDATE Instance method Public Method 20100325
10 SET_PARAM Instance method Public Method 20100325
11 SET_PARAM_TABLE Instance method Public Method 20130607
Events
Interface IF_TREX_SQL has no event.
Types
Interface IF_TREX_SQL has no local type.
Method Signatures

Method CALL_WITH_XSTRING Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing FUNC_NAME Call by reference Type reference (TYPE) CLIKE 20100325
2 Importing REQUEST_X Call by reference Type reference (TYPE) XSEQUENCE 20100325
3 Exporting RESPONSE_X Call by reference Type reference (TYPE) XSEQUENCE 20100325
# Exception Resumable Description Created on
1 CX_TREX_BAD_REQUEST 20100325
2 CX_TREX_REMOTE_COMMUNICATION 20100325
3 CX_TREX_SQL_EXCEPTION Exception Class for SQL Error 20100902

Method CLEAR_PARAMETERS Signature

Method CLEAR_PARAMETERS on Interface IF_TREX_SQL has no parameter.
Method CLEAR_PARAMETERS on Interface IF_TREX_SQL has no exception.

Method CLOSE Signature

Method CLOSE on Interface IF_TREX_SQL has no parameter.
Method CLOSE on Interface IF_TREX_SQL has no exception.

Method EXECUTE_DDL Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing STATEMENT Call by reference Type reference (TYPE) CSEQUENCE 20100326
# Exception Resumable Description Created on
1 CX_TREX_SQL_EXCEPTION Ausnahmeklasse für SQL Fehler 20100622

Method EXECUTE_PROCEDURE Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing PROC_NAME Call by reference Type reference (TYPE) CLIKE 20110513
# Exception Resumable Description Created on
1 CX_TREX_BAD_REQUEST Unexpected data received from application. 20110513
2 CX_TREX_SQL_EXCEPTION TREX SQL exception 20110513

Method EXECUTE_QUERY_COUNT_ONLY Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Returning RVAL Value transfer Type reference (TYPE) I 20100325
2 Importing STATEMENT Call by reference Type reference (TYPE) CSEQUENCE 20100325
# Exception Resumable Description Created on
1 CX_TREX_SQL_EXCEPTION 20100622

Method EXECUTE_QUERY_ITAB Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing CORRESPONDING_FIELDS Call by reference Type reference (TYPE) ADBC_COLUMN_TAB 20100325
2 Exporting ITAB Call by reference Type reference (TYPE) STANDARD TABLE 20100325
3 Importing LOB_FIELDS Call by reference Type reference (TYPE) ADBC_COLUMN_TAB 20101209
4 Importing STATEMENT Call by reference Type reference (TYPE) CSEQUENCE 20100325
# Exception Resumable Description Created on
1 CX_TREX_SQL_EXCEPTION 20100622

Method EXECUTE_QUERY_SINGLE_FIELD Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Exporting RESULT Call by reference Type reference (TYPE) ANY 20130424
2 Importing STATEMENT Call by reference Type reference (TYPE) CSEQUENCE 20130424
# Exception Resumable Description Created on
1 CX_TREX_SQL_EXCEPTION TREX SQL exception 20130424

Method EXECUTE_UPDATE Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Returning ROWS_PROCESSED Value transfer Type reference (TYPE) I 20100325
2 Importing STATEMENT Call by reference Type reference (TYPE) CSEQUENCE 20100325
# Exception Resumable Description Created on
1 CX_TREX_SQL_EXCEPTION Ausnahmeklasse für SQL Fehler 20100622

Method SET_PARAM Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing DATA_REF Call by reference Object reference (TYPE REF TO) DATA 20100325
2 Importing INOUT Call by reference Type reference (TYPE) TYPINT1 CL_SQL_STATEMENT=>C_PARAM_IN Referenz-Datenelement "TYPINT1" zu DATLDREF 20100325

Method SET_PARAM on Interface IF_TREX_SQL has no exception.

Method SET_PARAM_TABLE Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing TABLE_REF Call by reference Object reference (TYPE REF TO) DATA 20130607
# Exception Resumable Description Created on
1 CX_PARAMETER_INVALID Superclass for Parameter Error 20130607
History
Last changed by/on SAP  20140121 
SAP Release Created in 800