SAP ABAP Class CL_DB6_RDI_SQL (DB6: Free-Style SQL Access to RDI Backend)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DB-DB6 (Application Component) DB2 Universal Database for UNIX / NT
     ⤷ STU6 (Package) DB6: Performance-Monitor (UNIX/Windows)

Properties

Class	CL_DB6_RDI_SQL
Short Description	DB6: Free-Style SQL Access to RDI Backend
Super Class
Instantiability of a Class	2	Public
Final	☑

General Data

Message Class
Program status
Category	0
Package	STU6	DB6: Performance-Monitor (UNIX/Windows)
Created	20100126	SAP
Last change	20110908	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	DB6CC	Type group use (TYPE-POOLS tp)	Type group use (TYPE-POOLS tp)

Interfaces

Class CL_DB6_RDI_SQL has no interface implemented.

Friends

Class CL_DB6_RDI_SQL has no friend class.

Attributes

Class CL_DB6_RDI_SQL has no attribute.

Methods

#	Method	Level	Visibility	Method type	Description	Created on
1	GET_MATERIALIZATION_CANDIDATES	Static method	Public	Method	check for unnecessarily materialized tables	20100128
2	GET_MATERIALIZATION_SAVINGS	Static method	Public	Method	check for unnecessarily materialized tables	20100128
3	GET_STAGING_TABLE_NAME	Static method	Private	Method		20100127
4	GET_TABLE_SIZE	Static method	Public	Method		20100126
5	GET_V97_LAST_EXECUTABLE_ID	Static method	Public	Method		20100602
6	IS_EXISTING_STAGING_TABLE	Static method	Public	Method		20100127
7	RESOLVE_COMP_ENV	Static method	Public	Method		20100708

Events

Class CL_DB6_RDI_SQL has no event.

Types

Class CL_DB6_RDI_SQL has no local type.

Method Signatures

Method GET_MATERIALIZATION_CANDIDATES Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	EMPTY_TABS	Value transfer	☐	Type reference (TYPE)	DB6PSEUDOTAB_TAB		DB6 CCMS: Table of DB6PSEUDOTAB	20100128
2	Importing	SYS_REF	Call by reference	☐	Object reference (TYPE REF TO)	CL_DB6_SYS		DB6: Remote System Administration	20100128

#	Exception	Resumable	Description	Created on
1	CX_DBA_ADBC	☐	DBA Cockpit: ADBC Errors	20100128

Method GET_MATERIALIZATION_SAVINGS Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	SAVINGS_GB	Value transfer	☐	Type reference (TYPE)	DB6CC_PACKED_INT64		DB6 CCMS: Table of DB6PSEUDOTAB	20100128
2	Importing	SYS_REF	Call by reference	☐	Object reference (TYPE REF TO)	CL_DB6_SYS		DB6: Remote System Administration	20100128

#	Exception	Resumable	Description	Created on
1	CX_DBA_ADBC	☐	DBA Cockpit: ADBC Errors	20100128

Method GET_STAGING_TABLE_NAME Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	PREFIX	Call by reference	☐	Type reference (TYPE)	DB6_DBH_ROUTINE_NAME		DB6-DBH: Routine Name (UDF/SP)	20100127
2	Returning	TABNAME	Value transfer	☐	Type reference (TYPE)	STRING			20100127

Method GET_STAGING_TABLE_NAME on class CL_DB6_RDI_SQL has no exception.

Method GET_TABLE_SIZE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	CARD	Call by reference	☐	Type reference (TYPE)	P			20100127
2	Exporting	INDEX_SIZE	Call by reference	☐	Type reference (TYPE)	P			20100127
3	Exporting	STATS_TIME	Call by reference	☐	Type reference (TYPE)	DB6DATETIM		DB6: Timestamp (Format: YYYYMMDDHHMMSS)	20100127
4	Importing	SYS_REF	Call by reference	☐	Object reference (TYPE REF TO)	CL_DB6_SYS		DB6: Remote System Administration	20100126
5	Exporting	TABLE_SIZE	Call by reference	☐	Type reference (TYPE)	P			20100127
6	Importing	TABNAME	Call by reference	☐	Type reference (TYPE)	CLIKE			20100126
7	Importing	TABSCHEMA	Call by reference	☐	Type reference (TYPE)	CLIKE			20100126

#	Exception	Resumable	Description	Created on
1	CX_DBA_ADBC	☐	DBA Cockpit: ADBC Errors	20100126

Method GET_V97_LAST_EXECUTABLE_ID Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	APPLICATION_HANDLE	Call by reference	☐	Type reference (TYPE)	DB6MON_UOW-APPLICATION_HANDLE			20100602
2	Returning	LAST_EXECUTABLE_ID	Value transfer	☐	Type reference (TYPE)	DB6MON_UOW-LAST_EXECUTABLE_ID			20100602
3	Importing	SYS_REF	Call by reference	☐	Object reference (TYPE REF TO)	CL_DB6_SYS		DB6: Remote System Administration	20100602

#	Exception	Resumable	Description	Created on
1	CX_DBA_ADBC	☐	DBA Cockpit: ADBC Errors	20100602

Method IS_EXISTING_STAGING_TABLE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	EXISTING	Value transfer	☐	Type reference (TYPE)	ABAP_BOOL			20100127
2	Importing	PREFIX	Call by reference	☐	Type reference (TYPE)	DB6_DBH_ROUTINE_NAME		DB6-DBH: Routine Name (UDF/SP)	20100127
3	Importing	SYS_REF	Call by reference	☐	Object reference (TYPE REF TO)	CL_DB6_SYS		DB6: Remote System Administration	20100127

#	Exception	Resumable	Description	Created on
1	CX_DBA_ADBC	☐	DBA Cockpit: ADBC Errors	20100127

Method RESOLVE_COMP_ENV Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	COMP_ENV	Value transfer	☐	Type reference (TYPE)	DB6_CMPLENV_TAB		DB6: Table of DB6_CMPLENV	20100708
2	Importing	COMP_ENV_DESC	Call by reference	☐	Type reference (TYPE)	XSTRING			20100708
3	Importing	SYSTEM	Call by reference	☐	Object reference (TYPE REF TO)	CL_DB6_SYS		DB6: Remote System Administration	20100708

#	Exception	Resumable	Description	Created on
1	CX_DBA_ADBC	☐	DBA Cockpit: ADBC Errors	20100708

History

Last changed by/on	SAP	20110908
SAP Release Created in	730