SAP ABAP Class CL_SQL_PARAMETERS (Administrates Input and Output Parameters of SQL Statements)

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)

Properties

Class	CL_SQL_PARAMETERS
Short Description	Administrates Input and Output Parameters of SQL Statements
Super Class
Instantiability of a Class	0	Private
Final	☑

General Data

Message Class
Program status
Category	0
Package	SDB_ADBC	ABAP Database Call Interface (Dynamic SQL)
Created	20011019	SAP
Last change	20130531	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)
3	CL_SQL_STATEMENT	Forward declaration class (CLASS c DEFINITION DEFERRED)	Forward declaration class (CLASS c DEFINITION DEFERRED)

Interfaces

Class CL_SQL_PARAMETERS has no interface implemented.

Friends

#	Friend	Modeled only	Created on	Description
1	CL_SQL_RESULT_SET	☐	20011019	Resulting Set of an SQL Query
2	CL_SQL_STATEMENT	☐	20011019	SQL statement

Attributes

#	Attribute	Level	Visibility	Read only	Typing	Associated Type	Initial Value	Description	Created on
1	C_BLOB_LOCATOR	Instance attribute	Private	☐	Type reference (TYPE)	FLAGBYTE	2	BLOB Locator	20090203
2	C_CLOB_LOCATOR	Instance attribute	Private	☐	Type reference (TYPE)	FLAGBYTE	4	CLOB Locator	20090203
3	C_IS_LOB	Instance attribute	Private	☐	Type reference (TYPE)	FLAGBYTE	8	Field is an LOB	20090203
4	C_NULL_INDICATOR	Instance attribute	Private	☐	Type reference (TYPE)	FLAGBYTE	1	NULL value indicator set	20090203
5	C_PARAM_IN	Constant	Private	☐	Type reference (TYPE)	TYPINT1	0	Input Parameter	20011019
6	C_PARAM_INOUT	Constant	Private	☐	Type reference (TYPE)	TYPINT1	2	Input/Output Parameters	20011019
7	C_PARAM_OUT	Constant	Private	☐	Type reference (TYPE)	TYPINT1	1	Output Parameters	20011019
8	C_PTYPE_ANY	Constant	Private	☐	Type reference (TYPE)	TYPINT1	0	Parameter of Any Type	20011019
9	C_PTYPE_BLOB	Constant	Private	☐	Type reference (TYPE)	TYPINT1	1	BLOB Parameter	20011019
10	C_PTYPE_CLOB	Constant	Private	☐	Type reference (TYPE)	TYPINT1	2	CLOB Parameter	20011019
11	PARAM_TAB	Instance attribute	Private	☐	Type reference (TYPE)	PARAM_DESCR_TAB		Input and Output Parameters in SQL Statements	20011019

Methods

#	Method	Level	Visibility	Method type	Description	Created on
1	ADD_COMP_REF	Instance method	Private	Method	Sets New Reference to a Structure Component	20040813
2	CLEAR	Instance method	Private	Method	Deletes All Previously Set Parameters	20011019
3	IS_SIMPLE_TYPE	Static method	Private	Method	Checks Whether a Given Type Is a Simple ABAP Type	20020522
4	SET_PARAM_BY_REF	Instance method	Private	Method	Set Parameter Specified in a Reference	20011019
5	SET_PARAM_STRUCT	Instance method	Private	Method	Sets References to Structure Components as Parameters	20011019

Events

Class CL_SQL_PARAMETERS has no event.

Types

Class CL_SQL_PARAMETERS has no local type.

Method Signatures

Method ADD_COMP_REF Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	COMP_DESCR	Call by reference	☐	Type reference (TYPE)	ABAP_COMPDESCR		Beschreibung einer Strukturkomponente	20040813
2	Importing	LOB_FIELDS	Call by reference	☑	Type reference (TYPE)	ADBC_COLUMN_TAB		Liste der LOB-Felder	20090203
3	Importing	STRUCT	Call by reference	☐	Type reference (TYPE)	ANY		Eine Struktur	20040813

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

Method CLEAR Signature

Method CLEAR on class CL_SQL_PARAMETERS has no parameter.
Method CLEAR on class CL_SQL_PARAMETERS has no exception.

Method IS_SIMPLE_TYPE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	FLAG	Value transfer	☐	Type reference (TYPE)	FLAG		einfacher oder strukturierter Typ?	20020522
2	Importing	TYPE_KIND	Call by reference	☐	Type reference (TYPE)	ABAP_TYPEKIND			20020522

Method IS_SIMPLE_TYPE on class CL_SQL_PARAMETERS has no exception.

Method SET_PARAM_BY_REF 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	20011019
2	Importing	IND_REF	Call by reference	☑	Object reference (TYPE REF TO)	INT2		Referenz auf eine Indikatorvariable	20011019
3	Importing	INOUT	Call by reference	☐	Type reference (TYPE)	TYPINT1		IN/OUT Parameter	20011019
4	Importing	IS_LOB	Call by reference	☐	Type reference (TYPE)	FLAG	SPACE	allgemeines flag	20011024
5	Importing	PARAM_TYPE	Call by reference	☐	Type reference (TYPE)	TYPINT1	C_PTYPE_ANY	Parametertyp	20011019
6	Importing	POS	Call by reference	☐	Type reference (TYPE)	INT2	0	2 Byte Integer (Signed)	20011019

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

Method SET_PARAM_STRUCT 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		Liste von Feldern der Struktur	20040812
2	Importing	LOB_FIELDS	Call by reference	☑	Type reference (TYPE)	ADBC_COLUMN_TAB		Liste der LOB-Felder	20090203
3	Importing	STRUCT_REF	Call by reference	☐	Object reference (TYPE REF TO)	DATA		Referenz auf eine Struktur	20040813

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

History

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