SAP ABAP Class CL_SQL_RESULT_SET (Resulting Set of an SQL Query)

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_RESULT_SET
Short Description	Resulting Set of an SQL Query
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	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	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_ABAP_TYPEDESCR	Forward declaration class (CLASS c DEFINITION DEFERRED)	Forward declaration class (CLASS c DEFINITION DEFERRED)

Interfaces

Class CL_SQL_RESULT_SET 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	CON_REF	Instance attribute	Private	☐	Object reference (TYPE REF TO)	CL_SQL_CONNECTION		Database Connection	20001208
2	CURSOR	Instance attribute	Private	☐	Type reference (TYPE)	CURSOR	C_INVALID_CURSOR	Database Cursor	20001212
3	C_FCODE_CLOSE_CURSOR	Constant	Private	☐	Type reference (TYPE)	L_FCODE_T	'CC'	Function Code "CLOSE_CURSOR"	20030703
4	C_FCODE_FETCH_CURSOR	Constant	Private	☐	Type reference (TYPE)	L_FCODE_T	'NC'	Function Code "FETCH CURSOR"	20030703
5	C_FCODE_FREE_CURSOR	Constant	Private	☐	Type reference (TYPE)	L_FCODE_T	'FC'	Function Code "FREE CURSOR"	20030704
6	C_FCODE_NEXT_PACKAGE	Constant	Private	☐	Type reference (TYPE)	L_FCODE_T	'NP'	Function Code "NEXT PACKAGE"	20031113
7	C_INVALID_CURSOR	Constant	Private	☐	Type reference (TYPE)	CURSOR	-1	Invalid Cursor	20010502
8	C_MAX_INT	Constant	Private	☐	Type reference (TYPE)	ABAP_MSIZE	2147483647	Maximum number displayable with type I	20120920
9	C_MD_TYPE_C	Constant	Public	☐	Type reference (TYPE)	ADBC_METADATA_TYPE	CL_ABAP_TYPEDESCR=>TYPEKIND_CHAR	Data Type "C"	20100527
10	C_MD_TYPE_DECFLOAT16	Constant	Public	☐	Type reference (TYPE)	ADBC_METADATA_TYPE	'decfloat16'	Data Type "DECFLOAT16"	20100526
11	C_MD_TYPE_DECFLOAT34	Constant	Public	☐	Type reference (TYPE)	ADBC_METADATA_TYPE	'decfloat34'	Data Type "DECFLOAT34"	20100526
12	C_MD_TYPE_F	Constant	Public	☐	Type reference (TYPE)	ADBC_METADATA_TYPE	CL_ABAP_TYPEDESCR=>TYPEKIND_FLOAT	Data Type "F"	20100527
13	C_MD_TYPE_I	Constant	Public	☐	Type reference (TYPE)	ADBC_METADATA_TYPE	CL_ABAP_TYPEDESCR=>TYPEKIND_INT	Data type "I"	20100527
14	C_MD_TYPE_P	Constant	Public	☐	Type reference (TYPE)	ADBC_METADATA_TYPE	CL_ABAP_TYPEDESCR=>TYPEKIND_PACKED	Data Type "P"	20100527
15	C_MD_TYPE_STRING	Constant	Public	☐	Type reference (TYPE)	ADBC_METADATA_TYPE	'string'	Data Type "STRING"	20100526
16	C_MD_TYPE_X	Constant	Public	☐	Type reference (TYPE)	ADBC_METADATA_TYPE	CL_ABAP_TYPEDESCR=>TYPEKIND_HEX	Data Type "X"	20100527
17	C_MD_TYPE_XSTRING	Constant	Public	☐	Type reference (TYPE)	ADBC_METADATA_TYPE	'xstring'	Data Type "XSTRING"	20100526
18	FREE_CURSOR	Instance attribute	Private	☐	Type reference (TYPE)	FLAG		Release Cursor at Close()?	20030704
19	IS_CLOSED	Instance attribute	Private	☐	Type reference (TYPE)	FLAG	SPACE	Result Set Closed?	20100625
20	ITAB_LINE_REF	Instance attribute	Private	☐	Object reference (TYPE REF TO)	DATA		Reference to a Table Row	20001219
21	ITAB_REF	Instance attribute	Private	☐	Object reference (TYPE REF TO)	DATA		Reference to an Internal Table	20001218
22	OUTVALS_BOUND	Instance attribute	Private	☐	Type reference (TYPE)	FLAG		General Flag	20010319
23	PARAMETERS	Instance attribute	Private	☐	Object reference (TYPE REF TO)	CL_SQL_PARAMETERS		Output Parameters	20030703
24	ROWS_FETCHED	Instance attribute	Public	☑	Type reference (TYPE)	I	0	Number of Data Records Read So Far	20001208
25	ROWS_FETCHED_BIG	Instance attribute	Public	☑	Type reference (TYPE)	ABAP_MSIZE	0	Number of Data Records Read So Far	20120920

Methods

#	Method	Level	Visibility	Method type	Description	Created on
1	ADD_TO_ROWS_FETCHED	Instance method	Private	Method	Increment the ROWS_FETCHED[_BIG attributes	20120927
2	CLEAR_PARAMETERS	Instance method	Public	Method	Reset Output Parameters of Results	20010530
3	CLOSE	Instance method	Public	Method	Close Resulting Set	20001208
4	CLOSE_CURSOR	Instance method	Private	Method	Close DSQL Cursor	20090318
5	CONSTRUCTOR	Instance method	Public	Constructor	Constructor	20001208
6	GET_METADATA	Instance method	Public	Method	Type Information for the Output Columns of a Query	20090318
7	GET_STRUCT_REF	Instance method	Public	Method	Generates an ABAP Structure with Type Info from GET_METADATA	20090318
8	NEXT	Instance method	Public	Method	Get Next Record in the Resulting Set	20001208
9	NEXT_PACKAGE	Instance method	Public	Method	Read Next Set of Data Records into the Internal Table	20031118
10	SET_PARAM	Instance method	Public	Method	Set Reference to Output Parameter	20001212
11	SET_PARAM_BLOB	Instance method	Public	Method	Set Output Parameters	20010329
12	SET_PARAM_CLOB	Instance method	Public	Method	Set Output Parameters	20010328
13	SET_PARAM_STRUCT	Instance method	Public	Method	Set Structure as Output Parameters	20001219
14	SET_PARAM_TABLE	Instance method	Public	Method	Set Internal Table as Output Parameters	20001219
15	VALIDATE	Instance method	Private	Method	Checks whether this result set object is still valid	20100625

Events

Class CL_SQL_RESULT_SET 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 ADD_TO_ROWS_FETCHED Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IV_ROW_CNT	Call by reference	☐	Type reference (TYPE)	I		Wert um den inkrementiert werden soll	20120927

Method ADD_TO_ROWS_FETCHED on class CL_SQL_RESULT_SET has no exception.

Method CLEAR_PARAMETERS Signature

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

Method CLOSE Signature

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

Method CLOSE_CURSOR Signature

Method CLOSE_CURSOR on class CL_SQL_RESULT_SET has no parameter.
Method CLOSE_CURSOR on class CL_SQL_RESULT_SET 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	20001208
2	Importing	CURSOR	Call by reference	☐	Type reference (TYPE)	CURSOR		Datenbank Cursor	20001208
3	Importing	FREE_CURSOR	Call by reference	☐	Type reference (TYPE)	FLAG		Cursor bei CLOSE() freigeben?	20030704

Method CONSTRUCTOR on class CL_SQL_RESULT_SET has no exception.

Method GET_METADATA Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	MD_TAB	Value transfer	☐	Type reference (TYPE)	ADBC_RS_METADATA_DESCR_TAB			20090318

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

Method GET_STRUCT_REF Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	MD_TAB	Call by reference	☐	Type reference (TYPE)	ADBC_RS_METADATA_DESCR_TAB			20090318
2	Importing	P_STRICT	Call by reference	☐	Type reference (TYPE)	ABAP_BOOL	ABAP_TRUE	Typerzeugung mit ABAP-OO Regeln? (s. CL_ABAP_STRUCT _DESCR)	20091016
3	Importing	STRING_ONLY	Call by reference	☐	Type reference (TYPE)	ABAP_BOOL	ABAP_FALSE	ABAP_TRUE means that char column is taken as string column	20090318
4	Returning	STRUCT_REF	Value transfer	☐	Object reference (TYPE REF TO)	DATA			20090318

#	Exception	Resumable	Description	Created on
1	CX_PARAMETER_INVALID_RANGE	☐	Parameter mit ungültigem Wertebereich	20100714
2	CX_SY_STRUCT_CREATION	☐	Ausnahme beim Erzeugen eines Strukturtyps	20100526

Method NEXT Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	ROWS_RET	Value transfer	☐	Type reference (TYPE)	I		Anzahl gelesener Sätze	20001208

#	Exception	Resumable	Description	Created on
1	CX_PARAMETER_INVALID_TYPE	☐	Parameter mit ungültigem Typ	20001208
2	CX_SQL_EXCEPTION	☐	Ausnahmeklasse für SQL Fehler	20001208

Method NEXT_PACKAGE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	ROWS_RET	Value transfer	☐	Type reference (TYPE)	I		Anzahl gelesener Datensätze	20031118
2	Importing	UPTO	Value transfer	☐	Type reference (TYPE)	I	0	max. Anzahl zu lesender Datensätze	20031118

#	Exception	Resumable	Description	Created on
1	CX_PARAMETER_INVALID_TYPE	☐	Parameter mit ungültigem Typ	20031118
2	CX_SQL_EXCEPTION	☐	Ausnahmeklasse für SQL Fehler	20031118

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 Ausgabevariable	20001212
2	Importing	IND_REF	Call by reference	☑	Object reference (TYPE REF TO)	INT2		Referenz auf Indikatorvariable	20001212
3	Importing	IS_LOB	Call by reference	☐	Type reference (TYPE)	FLAG	SPACE	Wird auf der DB eine LOB-Spalte referiert?	20011024
4	Importing	POS	Call by reference	☑	Type reference (TYPE)	INT2		2 Byte Integer (Signed)	20001212

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

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		Referenz auf Ausgabevariable	20010329
2	Importing	IND_REF	Call by reference	☑	Object reference (TYPE REF TO)	INT2		Referenz auf Indikatorvariable	20010329
3	Importing	POS	Call by reference	☑	Type reference (TYPE)	INT2		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 Indikatorvariable	20010328
3	Importing	POS	Call by reference	☑	Type reference (TYPE)	INT2		2 Byte Integer (Signed)	20010328

Method SET_PARAM_CLOB on class CL_SQL_RESULT_SET has no exception.

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 Ausgabestruktur	20040812
2	Importing	LOB_FIELDS	Call by reference	☑	Type reference (TYPE)	ADBC_COLUMN_TAB		Lob-Felder	20090204
3	Importing	STRUCT_REF	Call by reference	☐	Object reference (TYPE REF TO)	DATA		Referenz auf Ausgabevariable	20001219

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

Method SET_PARAM_TABLE 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 Spalten der internen Tabelle	20040812
2	Importing	ITAB_REF	Call by reference	☐	Object reference (TYPE REF TO)	DATA		Referenz auf Ausgabevariable	20010308
3	Importing	LOB_FIELDS	Call by reference	☑	Type reference (TYPE)	ADBC_COLUMN_TAB		Liste der LOB Felder	20090204

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

Method VALIDATE Signature

Method VALIDATE on class CL_SQL_RESULT_SET has no parameter.

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

History

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