SAP ABAP Class CL_SQL_STATEMENT (SQL statement)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DB-DBI (Application Component) DB-Independent Database Interface
     ⤷ SDB_ADBC (Package) ABAP Database Call Interface (Dynamic SQL)

Meta Relationship - Used By

#	Relationship type	Used by	Short Description	Created on
1	Inheritance (c INHERITING FROM c_ref)	CL_SQL_PREPARED_STATEMENT	A Prepared SQL Statement	20001211

Properties

Class	CL_SQL_STATEMENT
Short Description	SQL statement
Super Class
Instantiability of a Class	2	Public
Final	☐

General Data

Message Class
Program status
Category	0
Package	SDB_ADBC	ABAP Database Call Interface (Dynamic SQL)
Created	20001208	SAP
Last change	20130531	SAP
Shared Memory-enabled	☐
Fixed point arithmetic	☑
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)
2	CL_SQL_PARAMETERS	Forward declaration class (CLASS c DEFINITION DEFERRED)	Forward declaration class (CLASS c DEFINITION DEFERRED)

Interfaces

Class CL_SQL_STATEMENT has no interface implemented.

Friends

Class CL_SQL_STATEMENT has no friend class.

Attributes

#	Attribute	Level	Visibility	Read only	Typing	Associated Type	Initial Value	Description	Created on
1	CON_REF	Instance attribute	Protected	☐	Object reference (TYPE REF TO)	CL_SQL_CONNECTION		Database Connection	20001208
2	C_FCODE_EXECUTE	Constant	Private	☐	Type reference (TYPE)	L_FCODE_T	'EX'	Function Code "EXECUTE"	20030703
3	C_FCODE_EXEC_IMMEDIATE	Constant	Private	☐	Type reference (TYPE)	L_FCODE_T	'EI'	Function Code "EXECUTE IMMEDIATE"	20030703
4	C_FCODE_EXEC_PROCEDURE	Constant	Private	☐	Type reference (TYPE)	L_FCODE_T	'EP'	Function Code "EXECUTE PROCEDURE"	20030703
5	C_FCODE_FREE_CURSOR	Constant	Private	☐	Type reference (TYPE)	L_FCODE_T	'FC'	Function Code "FREE CURSOR"	20030703
6	C_FCODE_OPEN_CURSOR	Constant	Private	☐	Type reference (TYPE)	L_FCODE_T	'OC'	Function Code "OPEN CURSOR"	20030703
7	C_FCODE_PREPARE	Constant	Private	☐	Type reference (TYPE)	L_FCODE_T	'PR'	Function Code "PREPARE"	20030703
8	C_FCODE_PREPARE_AND_OPEN	Constant	Private	☐	Type reference (TYPE)	L_FCODE_T	'PO'	Function Code "PREPARE AND OPEN CURSOR"	20031113
9	C_PARAM_IN	Constant	Public	☐	Type reference (TYPE)	TYPINT1	CL_SQL_PARAMETERS=>C_PARAM_IN	IN Parameter	20001212
10	C_PARAM_INOUT	Constant	Public	☐	Type reference (TYPE)	TYPINT1	CL_SQL_PARAMETERS=>C_PARAM_INOUT	INOUT Parameter	20001212
11	C_PARAM_OUT	Constant	Public	☐	Type reference (TYPE)	TYPINT1	CL_SQL_PARAMETERS=>C_PARAM_OUT	OUT Parameter	20001212
12	C_QUOTED_LOWERCASE	Constant	Public	☐	Type reference (TYPE)	TYPINT1	2	Identifier with Quotes in Lower-Case Letters	20030707
13	C_QUOTED_UPPERCASE	Constant	Public	☐	Type reference (TYPE)	TYPINT1	1	Identifier with Quotes in Upper-Case Letters	20030707
14	C_UNQUOTED	Constant	Public	☐	Type reference (TYPE)	TYPINT1	0	Identifier Without Quotes	20030707
15	ITAB_REF	Instance attribute	Private	☐	Object reference (TYPE REF TO)	DATA		Reference to Internal Table	20120404
16	PARAMETERS	Instance attribute	Protected	☐	Object reference (TYPE REF TO)	CL_SQL_PARAMETERS		Statement Parameter	20011019
17	TAB_NAME_FOR_TRACE	Instance attribute	Private	☐	Type reference (TYPE)	TABNAME		Table Name	20100625

Methods

#	Method	Level	Visibility	Method type	Description	Created on
1	CONSTRUCTOR	Instance method	Public	Constructor	Constructor	20001208
2	CREATE_COLUMN_LIST	Static method	Public	Method	Generates a Column List for a Given Structure	20030707
3	EXECUTE_DDL	Instance method	Public	Method	Execute a DDL Operation (For Example, CREATE TABLE)	20001208
4	EXECUTE_PROCEDURE	Instance method	Public	Method	Execute a "Stored Procedure"	20001208
5	EXECUTE_QUERY	Instance method	Public	Method	Execute an SQL Query	20031118
6	EXECUTE_UPDATE	Instance method	Public	Method	Execute a DML Operation (INSERT, UPDATE, DELETE)	20001208
7	GET_QUOTED_NAME	Static method	Private	Method	Encloses a Column Name in Quotation Marks	20030707
8	PREPARE	Instance method	Protected	Method	Prepare an SQL Statement	20030703
9	PREPARED_FREE	Instance method	Protected	Method	Release a Prepared SQL Statement	20030703
10	PREPARED_QUERY	Instance method	Protected	Method	Execute a Prepared Query	20030703
11	PREPARED_UPDATE	Instance method	Protected	Method	Execute a Prepared DML Operation	20030703
12	SET_PARAM	Instance method	Public	Method	Set an Input/Output Parameter	20001212
13	SET_PARAM_BLOB	Instance method	Public	Method	Set an Input/Output Parameter	20010329
14	SET_PARAM_CLOB	Instance method	Public	Method	Set an Input/Output Parameter	20010328
15	SET_PARAM_STRUCT	Instance method	Public	Method	Set Structure as Input Parameter	20030519
16	SET_PARAM_TABLE	Instance method	Public	Method	Set internal table as input parameter	20120402
17	SET_TABLE_NAME_FOR_TRACE	Instance method	Public	Method	Pass a Table Name for the SQL Trace	20100625

Events

Class CL_SQL_STATEMENT has no event.

Types

#	Type	Visibility	Typing	Associated Type	Description	Created on	Type Source
1	L_FCODE_T	Private	See coding			20030703	L_FCODE_T(2) type c

Method Signatures

Method CONSTRUCTOR Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	CON_REF	Call by reference	☑	Object reference (TYPE REF TO)	CL_SQL_CONNECTION		Datenbankverbindung	20001208
2	Importing	TAB_NAME_FOR_TRACE	Call by reference	☑	Type reference (TYPE)	TABNAME		Tabellenname	20120608

Method CONSTRUCTOR on class CL_SQL_STATEMENT has no exception.

Method CREATE_COLUMN_LIST 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		Referenz auf Struktur oder interne Tabelle	20030707
2	Importing	QUOTED	Call by reference	☐	Type reference (TYPE)	TYPINT1	C_UNQUOTED	Anführungszeichen um Spaltennamen?	20030707
3	Returning	SELECT_LIST	Value transfer	☐	Type reference (TYPE)	STRING			20030707

Method CREATE_COLUMN_LIST on class CL_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)	STRING		SQL Statement	20001208

#	Exception	Resumable	Description	Created on
1	CX_SQL_EXCEPTION	☐	Ausnahmeklasse für SQL Fehler	20001208

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)	C		Name der auszuführenden Prozedur	20001208
2	Returning	ROWS_PROCESSED	Value transfer	☐	Type reference (TYPE)	I		Anzahl prozessierter Datensätze	20010402

#	Exception	Resumable	Description	Created on
1	CX_SQL_EXCEPTION	☐	Ausnahmeklasse für SQL Fehler	20001208

Method EXECUTE_QUERY Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	HOLD_CURSOR	Call by reference	☐	Type reference (TYPE)	FLAG	SPACE		20031118
2	Returning	RESULT_SET	Value transfer	☐	Object reference (TYPE REF TO)	CL_SQL_RESULT_SET		Datenbank Cursor	20031118
3	Importing	STATEMENT	Call by reference	☑	Type reference (TYPE)	STRING		SELECT Statement, das ausgeführt wird	20031118

#	Exception	Resumable	Description	Created on
1	CX_PARAMETER_INVALID	☐	Oberklasse für Parameterfehler	20031118
2	CX_SQL_EXCEPTION	☐	Ausnahmeklasse für SQL Fehler	20031118

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		Anzahl prozessierter Datensätze	20001208
2	Importing	STATEMENT	Call by reference	☑	Type reference (TYPE)	STRING		SQL Statement	20001208

#	Exception	Resumable	Description	Created on
1	CX_PARAMETER_INVALID	☐	Oberklasse für Parameterfehler	20001211
2	CX_SQL_EXCEPTION	☐	Ausnahmeklasse für SQL Fehler	20001208

Method GET_QUOTED_NAME Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	NAME	Value transfer	☐	Type reference (TYPE)	C		Feldname	20030707
2	Importing	QUOTED	Call by reference	☐	Type reference (TYPE)	TYPINT1		Groß- oder Kleinbuchstaben	20030707
3	Returning	QUOTED_NAME	Value transfer	☐	Type reference (TYPE)	STRING		Feldname in Anführungszeichen	20030707

Method GET_QUOTED_NAME on class CL_SQL_STATEMENT has no exception.

Method PREPARE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	CURSOR	Value transfer	☐	Type reference (TYPE)	CURSOR		Cursor-Id im Kernel	20030703
2	Importing	HOLD_CURSOR	Call by reference	☐	Type reference (TYPE)	FLAG	SPACE	Soll Cursor nach COMMIT geöffnet bleiben?	20030703
3	Importing	STATEMENT	Call by reference	☐	Type reference (TYPE)	STRING		SQL Statement	20030703

#	Exception	Resumable	Description	Created on
1	CX_SQL_EXCEPTION	☐	Ausnahmeklasse für SQL Fehler	20030703

Method PREPARED_FREE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	CURSOR	Call by reference	☐	Type reference (TYPE)	CURSOR		Datenbank Cursor	20030703

Method PREPARED_FREE on class CL_SQL_STATEMENT has no exception.

Method PREPARED_QUERY Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	CURSOR	Call by reference	☐	Type reference (TYPE)	CURSOR		Cursor-Id im Kernel	20030703
2	Importing	FREE_CURSOR	Call by reference	☐	Type reference (TYPE)	FLAG		Cursor freigeben?	20030704
3	Returning	RESULT_SET	Value transfer	☐	Object reference (TYPE REF TO)	CL_SQL_RESULT_SET		Ergebnismenge	20030703

#	Exception	Resumable	Description	Created on
1	CX_SQL_EXCEPTION	☐	Ausnahmeklasse für SQL Fehler	20030703

Method PREPARED_UPDATE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	CURSOR	Call by reference	☐	Type reference (TYPE)	CURSOR		Cursor-Id im Kernel	20030703
2	Returning	ROWS_PROCESSED	Value transfer	☐	Type reference (TYPE)	I		Anzahl geänderter Zeilen	20030703

#	Exception	Resumable	Description	Created on
1	CX_SQL_EXCEPTION	☐	Ausnahmeklasse für SQL Fehler	20030703

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		Referenz auf ein Datenobjekt	20001212
2	Importing	IND_REF	Call by reference	☑	Object reference (TYPE REF TO)	INT2		Referenz auf eine Indikatorvariable	20001212
3	Importing	INOUT	Call by reference	☐	Type reference (TYPE)	TYPINT1	C_PARAM_IN	IN/OUT Parameter	20001212
4	Importing	IS_LOB	Call by reference	☐	Type reference (TYPE)	FLAG	SPACE	Wird auf der DB eine LOB-Spalte referiert?	20090127
5	Importing	POS	Call by reference	☐	Type reference (TYPE)	INT2	0	2 Byte Integer (Signed)	20001212

#	Exception	Resumable	Description	Created on
1	CX_PARAMETER_INVALID	☐	Oberklasse für Parameterfehler	20001212

Method SET_PARAM_BLOB Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	BLOB_REF	Call by reference	☐	Object reference (TYPE REF TO)	CL_SQL_BLOB		CLOB Lokator	20010329
2	Importing	IND_REF	Call by reference	☑	Object reference (TYPE REF TO)	INT2		Referenz auf eine Indikatorvariable	20010329
3	Importing	INOUT	Call by reference	☐	Type reference (TYPE)	TYPINT1	C_PARAM_IN	IN/OUT Parameter	20010329
4	Importing	POS	Call by reference	☐	Type reference (TYPE)	INT2	0	2 Byte Integer (Signed)	20010329

#	Exception	Resumable	Description	Created on
1	CX_PARAMETER_INVALID	☐	Oberklasse für Parameterfehler	20010329

Method SET_PARAM_CLOB Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	CLOB_REF	Call by reference	☐	Object reference (TYPE REF TO)	CL_SQL_CLOB		CLOB Lokator	20010328
2	Importing	IND_REF	Call by reference	☑	Object reference (TYPE REF TO)	INT2		Referenz auf eine Indikatorvariable	20010328
3	Importing	INOUT	Call by reference	☐	Type reference (TYPE)	TYPINT1	C_PARAM_IN	IN/OUT Parameter	20010328
4	Importing	POS	Call by reference	☐	Type reference (TYPE)	INT2	0	2 Byte Integer (Signed)	20010328

#	Exception	Resumable	Description	Created on
1	CX_PARAMETER_INVALID	☐	Oberklasse für Parameterfehler	20010328

Method SET_PARAM_STRUCT Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	LOB_FIELDS	Call by reference	☑	Type reference (TYPE)	ADBC_COLUMN_TAB		Liste der LOB-Felder	20090203
2	Importing	STRUCT_REF	Call by reference	☐	Object reference (TYPE REF TO)	DATA		Referenz auf Eingabestruktur	20030519

#	Exception	Resumable	Description	Created on
1	CX_PARAMETER_INVALID	☐	Oberklasse für Parameterfehler	20030519

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			20120404

#	Exception	Resumable	Description	Created on
1	CX_PARAMETER_INVALID	☐		20120404

Method SET_TABLE_NAME_FOR_TRACE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	TABLE_NAME	Call by reference	☐	Type reference (TYPE)	TABNAME		Tabellenname	20100625

Method SET_TABLE_NAME_FOR_TRACE on class CL_SQL_STATEMENT has no exception.

History

Last changed by/on	SAP	20130531
SAP Release Created in	610