SAP ABAP Class CL_TREX_SQL_STATEMENT (TREX SQL statement)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-TRX-API (Application Component) TREX ABAP + JAVA API
     ⤷ STREX (Package) TREX ABAP client

Meta Relationship - Using

#	Relationship type	Using	Short Description	Created on
1	Interface implementation (CLASS c. INTERFACES i_ref)	IF_TREX_SQL	ADBC based SQL interface	20100325

Properties

Class	CL_TREX_SQL_STATEMENT
Short Description	TREX SQL statement
Super Class
Instantiability of a Class	2	Public
Final	☑

General Data

Message Class
Program status
Category	0
Package	STREX	TREX ABAP client
Created	20100325	SAP
Last change	20140121	SAP
Shared Memory-enabled	☐
Fixed point arithmetic	☑
Unicode checks active	☑

Forward declarations

#	Type group / Object type	Type	Type Description
1	ABAP	Type group use (TYPE-POOLS tp)	Type group use (TYPE-POOLS tp)
2	ADBC	Type group use (TYPE-POOLS tp)	Type group use (TYPE-POOLS tp)

Interfaces

#	Interface	Abstract	Final	Description	Created on
1	IF_TREX_SQL	☐	☐	ADBC based SQL interface	20100325

Friends

Class CL_TREX_SQL_STATEMENT has no friend class.

Attributes

#	Attribute	Level	Visibility	Read only	Typing	Associated Type	Initial Value	Description	Created on
1	SQL	Instance attribute	Private	☐	Object reference (TYPE REF TO)	CL_SQL_STATEMENT		SQL Statement	20100325

Methods

#	Method	Level	Visibility	Method type	Description	Created on
1	CALL_WITH_XSTRING	Instance method	Private	Method		20100325
2	CONSTRUCTOR	Instance method	Public	Constructor		20100325
3	EXECUTE_DDL	Instance method	Private	Method		20100325
4	EXECUTE_PROCEDURE	Instance method	Private	Method		20110513
5	EXECUTE_QUERY_COUNT_ONLY	Instance method	Private	Method		20100325
6	EXECUTE_QUERY_ITAB	Instance method	Private	Method		20100325
7	EXECUTE_QUERY_SINGLE_FIELD	Instance method	Private	Method		20130424
8	EXECUTE_UPDATE	Instance method	Private	Method		20100325
9	GEN_ROUTE_BY_TABLE	Static method	Private	Method		20121005
10	SHOULD_USE_TREXVIADBSLPARAM	Instance method	Private	Method		20121005

Events

Class CL_TREX_SQL_STATEMENT has no event.

Types

Class CL_TREX_SQL_STATEMENT 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_SQL_EXCEPTION	☐	Exception Class for SQL Error	20100331
2	CX_TREX_BAD_REQUEST	☐	Unexpected data received from application.	20100325
3	CX_TREX_REMOTE_COMMUNICATION	☐	Remote Communication Exception	20100325
4	CX_TREX_SQL_EXCEPTION	☐	TREX SQL exception	20121008

Method CONSTRUCTOR Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	CONNECTION	Call by reference	☑	Object reference (TYPE REF TO)	CL_SQL_CONNECTION		Datenbankverbindung	20100325

Method CONSTRUCTOR on class CL_TREX_SQL_STATEMENT 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			20100325

#	Exception	Resumable	Description	Created on
1	CX_SQL_EXCEPTION	☐	Exception Class for SQL Error	20100325
2	CX_TREX_BAD_REQUEST	☐	Unexpected data received from application.	20111014
3	CX_TREX_REMOTE_COMMUNICATION	☐	Remote Communication Exception	20111014

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_SQL_EXCEPTION	☐	Exception Class for SQL Error	20110513
2	CX_TREX_BAD_REQUEST	☐	Unexpected data received from application.	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_SQL_EXCEPTION	☐	Ausnahmeklasse für SQL Fehler	20100325

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)	STRING			20100325

#	Exception	Resumable	Description	Created on
1	CX_SQL_EXCEPTION	☐	Exception Class for SQL Error	20100325

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_SQL_EXCEPTION	☐	Exception Class for SQL Error	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_SQL_EXCEPTION	☐	Ausnahmeklasse für SQL Fehler	20100325

Method GEN_ROUTE_BY_TABLE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	REQUEST	Call by reference	☐	Type reference (TYPE)	XSTRING			20121005
2	Returning	RVAL	Value transfer	☐	Type reference (TYPE)	STRING			20121005

Method GEN_ROUTE_BY_TABLE on class CL_TREX_SQL_STATEMENT has no exception.

Method SHOULD_USE_TREXVIADBSLPARAM 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			20121005
2	Returning	RVAL	Value transfer	☐	Type reference (TYPE)	ABAP_BOOL		True: new TrexViaDbsl should be used	20121005

#	Exception	Resumable	Description	Created on
1	CX_SQL_EXCEPTION	☐	Exception Class for SQL Error	20121005
2	CX_TREX_BAD_REQUEST	☐		20121005
3	CX_TREX_REMOTE_COMMUNICATION	☐	Remote Communication Exception	20121008
4	CX_TREX_REMOTE_INITIALIZATION	☐		20121005
5	CX_TREX_SQL_EXCEPTION	☐		20121005

History

Last changed by/on	SAP	20140121
SAP Release Created in	800