SAP ABAP Class CL_SQL_PREPARED_STATEMENT (A Prepared 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 - Using

#	Relationship type	Using	Short Description	Created on
1	Inheritance (c INHERITING FROM c_ref)	CL_SQL_STATEMENT	SQL statement	20001211

Properties

Class	CL_SQL_PREPARED_STATEMENT
Short Description	A Prepared SQL Statement
Super Class	CL_SQL_STATEMENT	SQL statement
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	20140121	SAP
Shared Memory-enabled	☐
Fixed point arithmetic	☑
Unicode checks active	☑

Forward declarations

Class CL_SQL_PREPARED_STATEMENT has no forward declaration.

Interfaces

Class CL_SQL_PREPARED_STATEMENT has no interface implemented.

Friends

#	Friend	Modeled only	Created on	Description
1	CL_SQL_STATEMENT	☐	20030703	SQL statement

Attributes

#	Attribute	Level	Visibility	Read only	Typing	Associated Type	Initial Value	Description	Created on
1	CLEAR_PARAMS_NEEDED	Instance attribute	Private	☐	Type reference (TYPE)	FLAG	SPACE	Call CLEAR_PARAMETERS before next parameter change	20130701
2	CURSOR	Instance attribute	Private	☐	Type reference (TYPE)	CURSOR	C_INVALID_CURSOR	Identifier for Databse Cursor in Kernel	20030703
3	C_INVALID_CURSOR	Constant	Private	☐	Type reference (TYPE)	CURSOR	-1	Invalid Cursor	20030703
4	RES_REF	Instance attribute	Private	☐	Object reference (TYPE REF TO)	CL_SQL_RESULT_SET		Resulting Set of an SQL Query	20100625

Methods

#	Method	Level	Visibility	Method type	Description	Created on
1	CLEAR_PARAMETERS	Instance method	Public	Method	Reset Input Parameters of Statement	20010530
2	CLOSE	Instance method	Public	Method	Release a Prepared Statement	20001211
3	CONSTRUCTOR	Instance method	Public	Constructor	Constructor	20001208
4	VALIDATE	Instance method	Private	Method	Validates the statement or the associated DB connection	20100625

Events

Class CL_SQL_PREPARED_STATEMENT has no event.

Types

Class CL_SQL_PREPARED_STATEMENT has no local type.

Method Signatures

Method CLEAR_PARAMETERS Signature

Method CLEAR_PARAMETERS on class CL_SQL_PREPARED_STATEMENT has no parameter.
Method CLEAR_PARAMETERS on class CL_SQL_PREPARED_STATEMENT has no exception.

Method CLOSE Signature

Method CLOSE on class CL_SQL_PREPARED_STATEMENT has no parameter.
Method CLOSE on class CL_SQL_PREPARED_STATEMENT has no exception.

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	20001211
2	Importing	STATEMENT	Call by reference	☐	Type reference (TYPE)	STRING		SQL Statement	20001211
3	Importing	TAB_NAME_FOR_TRACE	Call by reference	☑	Type reference (TYPE)	TABNAME		Tabellenname	20120608

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

Method VALIDATE Signature

Method VALIDATE on class CL_SQL_PREPARED_STATEMENT has no parameter.

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

History

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