SAP ABAP Class CL_RSDRS_DB2_SQL_STMT (Generate an DB2 SQL Statement)

Hierarchy

☛ SAP_BW (Software Component) SAP Business Warehouse
   ⤷ BW-SYS-DB-DB2 (Application Component) BW DB2 for OS/390
     ⤷ RSDB2 (Package) BW: Porting DB2-z/OS

Meta Relationship - Using

#	Relationship type	Using	Short Description	Created on
1	Interface implementation (CLASS c. INTERFACES i_ref)	IF_RSDRS_SQL_STMT	Data Manager SQL Statement	20030624

Properties

Class	CL_RSDRS_DB2_SQL_STMT
Short Description	Generate an DB2 SQL Statement
Super Class
Instantiability of a Class	2	Public
Final	☑

General Data

Message Class
Program status
Category	0
Package	RSDB2	BW: Porting DB2-z/OS
Created	20030624	SAP
Last change	20130531	SAP
Shared Memory-enabled	☐
Fixed point arithmetic	☑
Unicode checks active	☑

Forward declarations

#	Type group / Object type	Type	Type Description
1	RS	Type group use (TYPE-POOLS tp)	Type group use (TYPE-POOLS tp)
2	RSD	Type group use (TYPE-POOLS tp)	Type group use (TYPE-POOLS tp)
3	RSDRH	Type group use (TYPE-POOLS tp)	Type group use (TYPE-POOLS tp)
4	RSDRS	Type group use (TYPE-POOLS tp)	Type group use (TYPE-POOLS tp)

Interfaces

#	Interface	Abstract	Final	Description	Created on
1	IF_RSDRS_SQL_STMT	☐	☐	Data Manager SQL Statement	20030624

Friends

#	Friend	Modeled only	Created on	Description
1	CL_RSDRS_DB2_EXITS	☐	20030624	Database dependent exits for DB2

Attributes

#	Attribute	Level	Visibility	Read only	Typing	Associated Type	Initial Value	Description	Created on
1	P_ACCESSCNT	Instance attribute	Private	☐	Type reference (TYPE)	I			20050815
2	P_DELETE_PACKAGESIZE	Instance attribute	Private	☐	Type reference (TYPE)	I	0	Package Size for Selective Deletion	20060907
3	P_DMUID	Instance attribute	Private	☐	Type reference (TYPE)	SYSUUID_25		UUID in Compressed Form	20050815
4	P_HIER_FACTOR	Instance attribute	Private	☐	Type reference (TYPE)	STRING		correction factor for unambiguous hierarchies	20030624
5	P_R_EXIT_OBJ	Instance attribute	Private	☐	Object reference (TYPE REF TO)	CL_RSDRS_DB2_EXITS		Reference to Database specific exits	20030624
6	P_SRV_OBJ	Instance attribute	Private	☐	Object reference (TYPE REF TO)	CL_RSDRS_STMT_SRVS		Service Object for Statement Creation	20030624
7	P_SX_QUERY	Instance attribute	Private	☐	Type reference (TYPE)	RSDRS_SX_QUERY		query definition	20030624
8	P_TH_COB_PRO	Instance attribute	Private	☐	Type reference (TYPE)	RSDRS_TH_COB_PRO		COB PRO information of sx_query	20030624
9	P_T_CODE	Instance attribute	Private	☐	Type reference (TYPE)	RSDRS_T_ABAPSOURCE		Generated Code	20030624
10	P_VIEWNM	Instance attribute	Private	☐	Type reference (TYPE)	RSD_TABLNM			20031027

Methods

#	Method	Level	Visibility	Method type	Description	Created on
1	ADD_TABLE_EXPRESSION_DB2	Instance method	Private	Method	Add Table Names and NTE if Necessary	20031027
2	BUILD_CHA_SELECT	Instance method	Private	Method	build an entry of char. and nav. attr. part of select list	20030624
3	BUILD_CTE_HINT	Instance method	Private	Method	Builds CTE Hint (if Required)	20111013
4	BUILD_DELETE_HEADER	Instance method	Private	Method	For db_delete build delete header	20050509
5	BUILD_FORMULA	Instance method	Private	Method	Builds the Select List / Having Entry for a Key Figure	20071126
6	BUILD_FROM_JOINS	Instance method	Private	Method	Build the from list with join conditions (ANSI Notation)	20030624
7	BUILD_GROUPBY_LIST	Instance method	Private	Method	Build group by part of statement	20030624
8	BUILD_HAVING_LIST	Instance method	Private	Method	Build the have list (not used currently)	20030624
9	BUILD_HINT	Instance method	Protected	Method	Generate DB2 Hint for SQL Statement	20031027
10	BUILD_INSERT_HEADER	Instance method	Private	Method	For db_insert or db_create build insert list, drop indexes	20030624
11	BUILD_KYF_SELECT	Instance method	Private	Method	Build Select List Entry for a Key Figure	20030624
12	BUILD_ORDERBY	Instance method	Private	Method	build order by list	20030624
13	BUILD_OUTER	Instance method	Private	Method	build a single outer join condition	20030624
14	BUILD_SUBQUERY	Instance method	Private	Method	build a subquery. Subqueries may occur within where cond.	20030624
15	BUILD_TOP_SELECT	Instance method	Private	Method	Generates the SELECT List of a Top N Query	20070312
16	BUILD_TOP_WHERE	Instance method	Private	Method	Generates WHERE Clause for Top N Queries	20070312
17	BUILD_WHERE_LIST	Instance method	Private	Method	Build the where list (without the join part)	20030624
18	CLEAR_CODE_DB2	Instance method	Private	Method	Delete Generated SQL Statement	20031027
19	CONSTRUCTOR	Instance method	Public	Constructor	Class constructor	20030624
20	DET_HIER_FACTOR	Instance method	Private	Method	Determine the correction factor for unambiguous hierarchies	20030624
21	DROP_PRIMARY_KEY_DB2	Instance method	Private	Method	Delete Unique Key for Result Table	20031027
22	GET_VIEWNM_DB2	Instance method	Public	Method	Deliver Assigned View Names	20031027
23	PROCESS_RECORDTP_RESTRICTION	Instance method	Private	Method	Adds Partitioning Condition for recordtp Restriction	20080827
24	PROCESS_ROWNUM_ON_TABLE	Instance method	Private	Method	Adds FETCH FIRST n ROWS ONLY for the table	20101104
25	PROCESS_TOPQUERY	Instance method	Private	Method	Generates a Top N Query	20070312
26	SPLIT_HEADER	Instance method	Private	Method	Splits Statement in Header and SELECT Statement	20070312
27	WRITE_JOIN	Instance method	Private	Method	recurse over from list and join tables together	20030624
28	WRITE_TABLE	Instance method	Private	Method	write a table entry of the from list	20030624

Events

Class CL_RSDRS_DB2_SQL_STMT has no event.

Types

Class CL_RSDRS_DB2_SQL_STMT has no local type.

Method Signatures

Method ADD_TABLE_EXPRESSION_DB2 Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_SEPARATOR	Call by reference	☑	Type reference (TYPE)	C			20031027
2	Importing	I_SUBQUERY_ID	Call by reference	☐	Type reference (TYPE)	RSDRS_SUBQUERY_ID			20101104
3	Importing	I_S_TABLE	Call by reference	☐	Type reference (TYPE)	RSDRS_S_TABLE			20101104

#	Exception	Resumable	Description	Created on
1	CX_RSDRS_STMT_TOO_LONG	☐	Generated Stmt is too long ...	20050224

Method BUILD_CHA_SELECT Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_SEPARATOR	Call by reference	☐	Type reference (TYPE)	RSDRS_SEP		Separator between list elements	20030624
2	Importing	I_S_CHA	Call by reference	☐	Type reference (TYPE)	RSDRS_S_CHA		actual characteristic to build entry for	20030624

#	Exception	Resumable	Description	Created on
1	CX_RSDRS_STMT_TOO_LONG	☐	SQL-Statement ist zu groß	20031027

Method BUILD_CTE_HINT Signature

Method BUILD_CTE_HINT on class CL_RSDRS_DB2_SQL_STMT has no parameter.

#	Exception	Resumable	Description	Created on
1	CX_RSDRS_STMT_TOO_LONG	☐	Generated statement is too long ...	20111013

Method BUILD_DELETE_HEADER Signature

Method BUILD_DELETE_HEADER on class CL_RSDRS_DB2_SQL_STMT has no parameter.

#	Exception	Resumable	Description	Created on
1	CX_RSDRS_STMT_TOO_LONG	☐	Generated Stmt is too long ...	20050509

Method BUILD_FORMULA Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_FORMULA	Call by reference	☐	Type reference (TYPE)	RSDRS_S_KYF-FORMULA		Formula	20071126
2	Importing	I_T_FORM_FLD	Call by reference	☐	Type reference (TYPE)	RSDRS_T_FORM_FLD		Factor for unambigous hierarchies	20071126
3	Returning	R_FORMULA	Value transfer	☐	Type reference (TYPE)	STRING		Resolved formula	20071126

Method BUILD_FORMULA on class CL_RSDRS_DB2_SQL_STMT has no exception.

Method BUILD_FROM_JOINS Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	E_WITH_WHERE_CLAUSE	Call by reference	☐	Type reference (TYPE)	RS_BOOL			20031027
2	Importing	I_SUBQUERY_ID	Call by reference	☐	Type reference (TYPE)	RSDRS_SUBQUERY_ID			20101104
3	Importing	I_TH_JOIN	Call by reference	☐	Type reference (TYPE)	RSDRS_TH_JOIN		List of inner join conditions	20030624
4	Importing	I_TH_TABLE	Call by reference	☐	Type reference (TYPE)	RSDRS_TH_TABLE		Table List	20030624
5	Importing	I_TX_LEFTOUTER	Call by reference	☐	Type reference (TYPE)	RSDRS_TX_LEFTOUTER		list of left outer joins	20030624

#	Exception	Resumable	Description	Created on
1	CX_RSDRS_STMT_TOO_LONG	☐	SQL-Statement ist zu groß	20031027

Method BUILD_GROUPBY_LIST Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_T_GROUPBY	Call by reference	☐	Type reference (TYPE)	RSDRS_T_GROUPBY		Groupby	20030624

#	Exception	Resumable	Description	Created on
1	CX_RSDRS_STMT_TOO_LONG	☐	SQL-Statement ist zu groß	20031027

Method BUILD_HAVING_LIST Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_T_HAVING	Call by reference	☐	Type reference (TYPE)	RSDRS_T_HAVING		Having list	20030624

#	Exception	Resumable	Description	Created on
1	CX_RSDRS_STMT_TOO_LONG	☐	SQL-Statement ist zu groß	20031027

Method BUILD_HINT Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	E_HINT	Call by reference	☐	Type reference (TYPE)	RS_CHAR255		Final hints ...	20031027
2	Importing	I_OPEN_SQL	Call by reference	☐	Type reference (TYPE)	RS_BOOL		Boolean	20031027
3	Importing	I_T_HINT	Call by reference	☐	Type reference (TYPE)	RSDRS_T_ABAPSOURCE		Hints from Statement (if set ...)	20031027

Method BUILD_HINT on class CL_RSDRS_DB2_SQL_STMT has no exception.

Method BUILD_INSERT_HEADER Signature

Method BUILD_INSERT_HEADER on class CL_RSDRS_DB2_SQL_STMT has no parameter.

#	Exception	Resumable	Description	Created on
1	CX_RSDRS_STMT_TOO_LONG	☐	SQL-Statement ist zu groß	20031027

Method BUILD_KYF_SELECT Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_HIER_FACTOR	Call by reference	☐	Type reference (TYPE)	STRING		factor for unambigous hierarchies	20030624
2	Importing	I_SEPARATOR	Call by reference	☐	Type reference (TYPE)	RSDRS_SEP		Separator for select list	20030624
3	Importing	I_S_KYF	Call by reference	☐	Type reference (TYPE)	RSDRS_S_KYF		key figure description	20030624

#	Exception	Resumable	Description	Created on
1	CX_RSDRS_STMT_TOO_LONG	☐	SQL-Statement ist zu groß	20031027

Method BUILD_ORDERBY Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_T_ORDERBY	Call by reference	☐	Type reference (TYPE)	RSDRS_T_ORDERBY		orderby list	20030624
2	Importing	I_USE_RETALIAS	Value transfer	☐	Type reference (TYPE)	RS_BOOL	RS_C_TRUE	Boolean	20101104

#	Exception	Resumable	Description	Created on
1	CX_RSDRS_STMT_TOO_LONG	☐	SQL-Statement ist zu groß	20031027

Method BUILD_OUTER Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Changing	C_TH_TBLS_JOINED	Call by reference	☐	Type reference (TYPE)	RSDRS_TH_TABLE		Tables already joined	20030624
2	Importing	I_SX_LEFTOUTER	Call by reference	☐	Type reference (TYPE)	RSDRS_SX_LEFTOUTER		left outer condition to build	20030624

#	Exception	Resumable	Description	Created on
1	CX_RSDRS_STMT_TOO_LONG	☐	SQL-Statement ist zu groß	20031027

Method BUILD_SUBQUERY Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_SUBQUERY_ID	Call by reference	☐	Type reference (TYPE)	RSDRS_SUBQUERY_ID		Subquery ID of actual subquery	20030624
2	Importing	I_SX_SUBQUERY	Call by reference	☐	Type reference (TYPE)	RSDRS_SX_SUBQUERY		Subquery description	20030624
3	Importing	I_S_WHERE	Call by reference	☐	Type reference (TYPE)	RSDRS_S_WHERE		Surrounding where statement	20030624

#	Exception	Resumable	Description	Created on
1	CX_RSDRS_STMT_TOO_LONG	☐	SQL-Statement ist zu groß	20031027

Method BUILD_TOP_SELECT Signature

Method BUILD_TOP_SELECT on class CL_RSDRS_DB2_SQL_STMT has no parameter.

#	Exception	Resumable	Description	Created on
1	CX_RSDRS_STMT_TOO_LONG	☐	Generated Stmt is too long ...	20070312

Method BUILD_TOP_WHERE Signature

Method BUILD_TOP_WHERE on class CL_RSDRS_DB2_SQL_STMT has no parameter.

#	Exception	Resumable	Description	Created on
1	CX_RSDRS_STMT_TOO_LONG	☐	Generated Stmt is too long ...	20070312

Method BUILD_WHERE_LIST Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_BOOLOP	Call by reference	☑	Type reference (TYPE)	RSDRS_BOOLOP			20031027
2	Importing	I_SUBQUERY_ID	Call by reference	☐	Type reference (TYPE)	RSDRS_SUBQUERY_ID		ID of actual subquery	20030624
3	Importing	I_T_WHERE	Call by reference	☐	Type reference (TYPE)	RSDRS_T_WHERE		Where List	20030624

#	Exception	Resumable	Description	Created on
1	CX_RSDRS_STMT_TOO_LONG	☐	SQL-Statement ist zu groß	20031027

Method CLEAR_CODE_DB2 Signature

Method CLEAR_CODE_DB2 on class CL_RSDRS_DB2_SQL_STMT has no parameter.
Method CLEAR_CODE_DB2 on class CL_RSDRS_DB2_SQL_STMT has no exception.

Method CONSTRUCTOR Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_SX_QUERY	Call by reference	☐	Type reference (TYPE)	RSDRS_SX_QUERY		Quey description	20030624

Method CONSTRUCTOR on class CL_RSDRS_DB2_SQL_STMT has no exception.

Method DET_HIER_FACTOR Signature

Method DET_HIER_FACTOR on class CL_RSDRS_DB2_SQL_STMT has no parameter.
Method DET_HIER_FACTOR on class CL_RSDRS_DB2_SQL_STMT has no exception.

Method DROP_PRIMARY_KEY_DB2 Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_TABLNM	Call by reference	☐	Type reference (TYPE)	RSDRS_RETURNOBJ			20031027

Method DROP_PRIMARY_KEY_DB2 on class CL_RSDRS_DB2_SQL_STMT has no exception.

Method GET_VIEWNM_DB2 Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	E_VIEWNM	Call by reference	☐	Type reference (TYPE)	RSD_TABLNM			20031027

Method GET_VIEWNM_DB2 on class CL_RSDRS_DB2_SQL_STMT has no exception.

Method PROCESS_RECORDTP_RESTRICTION Signature

Method PROCESS_RECORDTP_RESTRICTION on class CL_RSDRS_DB2_SQL_STMT has no parameter.
Method PROCESS_RECORDTP_RESTRICTION on class CL_RSDRS_DB2_SQL_STMT has no exception.

Method PROCESS_ROWNUM_ON_TABLE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_SEPARATOR	Value transfer	☐	Type reference (TYPE)	RS_CHAR3			20101104
2	Importing	I_SUBQUERY_ID	Call by reference	☐	Type reference (TYPE)	RSDRS_SUBQUERY_ID			20101104
3	Importing	I_S_TABLE	Call by reference	☐	Type reference (TYPE)	RSDRS_S_TABLE			20101104
4	Returning	R_PROCESSED	Value transfer	☐	Type reference (TYPE)	RS_BOOL		Boolean	20101104

#	Exception	Resumable	Description	Created on
1	CX_RSDRS_STMT_TOO_LONG	☐	Generated Stmt is too long ...	20101104

Method PROCESS_TOPQUERY Signature

Method PROCESS_TOPQUERY on class CL_RSDRS_DB2_SQL_STMT has no parameter.

#	Exception	Resumable	Description	Created on
1	CX_RSDRS_STMT_TOO_LONG	☐	Generated Stmt is too long ...	20070518

Method SPLIT_HEADER Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Changing	C_T_CODE	Call by reference	☐	Type reference (TYPE)	RSDRS_T_ABAPSOURCE			20070312
2	Exporting	E_T_HEADER	Call by reference	☐	Type reference (TYPE)	RSDRS_T_ABAPSOURCE			20070312

Method SPLIT_HEADER on class CL_RSDRS_DB2_SQL_STMT has no exception.

Method WRITE_JOIN Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Changing	C_TH_TBLS_JOINED	Call by reference	☐	Type reference (TYPE)	RSDRS_TH_TABLE		Tables that have already been joined	20030624
2	Changing	C_TS_JOIN	Call by reference	☐	Type reference (TYPE)	RSDRS_TS_JOIN		Join list to work on	20030624
3	Changing	C_T_FROM	Call by reference	☐	Type reference (TYPE)	RSDRS_T_ABAPSOURCE		Generated code	20030624
4	Importing	I_STARTTAB	Call by reference	☐	Type reference (TYPE)	RSDRS_ALIAS		Table to start with	20030624
5	Importing	I_SUBQUERY_ID	Call by reference	☐	Type reference (TYPE)	RSDRS_SUBQUERY_ID			20101104
6	Importing	I_TH_TABLE	Call by reference	☐	Type reference (TYPE)	RSDRS_TH_TABLE		List of Tables	20030624

#	Exception	Resumable	Description	Created on
1	CX_RSDRS_STMT_TOO_LONG	☐	Generated Stmt is too long ...	20050224

Method WRITE_TABLE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Changing	C_TH_TBLS_JOINED	Call by reference	☐	Type reference (TYPE)	RSDRS_TH_TABLE		tables already joined	20030624
2	Changing	C_T_FROM	Call by reference	☐	Type reference (TYPE)	RSDRS_T_ABAPSOURCE		generated code	20030624
3	Importing	I_SUBQUERY_ID	Call by reference	☐	Type reference (TYPE)	RSDRS_SUBQUERY_ID			20101104
4	Importing	I_TABALIAS	Call by reference	☐	Type reference (TYPE)	RSDRS_ALIAS		alias of table to write	20030624
5	Importing	I_TH_TABLE	Call by reference	☐	Type reference (TYPE)	RSDRS_TH_TABLE		list of tables	20030624

#	Exception	Resumable	Description	Created on
1	CX_RSDRS_STMT_TOO_LONG	☐		20050224

History

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