SAP ABAP Class CL_DB6_EXPLAIN_UTIL (DB6 Utilities for EXPLAIN)

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_EXPLAIN_UTIL
Short Description	DB6 Utilities for EXPLAIN
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	20061220	SAP
Last change	20110908	SAP
Shared Memory-enabled	☐
Fixed point arithmetic	☑
Unicode checks active	☑

Forward declarations

Class CL_DB6_EXPLAIN_UTIL has no forward declaration.

Interfaces

Class CL_DB6_EXPLAIN_UTIL has no interface implemented.

Friends

Class CL_DB6_EXPLAIN_UTIL has no friend class.

Attributes

#	Attribute	Level	Visibility	Read only	Typing	Associated Type	Initial Value	Description	Created on
1	ST05_PARAM_VALUES	Static Attribute	Private	☐	Type reference (TYPE)	STRING			20080904

Methods

#	Method	Level	Visibility	Method type	Description	Created on
1	COLLECTPREDICATES	Static method	Private	Method	collect Predicates for real rows returned calculation	20061220
2	COLLECTTABLES	Static method	Private	Method	generate list of tables to select cardinality	20061220
3	GENERATEREALCARDSTATEMENT	Static method	Public	Method	generate stmt. to calculate number of returned rows at node	20070108
4	GENERATERETURNEDROWSSTATEMENT	Static method	Public	Method	generate stmt. to calculate number of returned rows at node	20061220
5	GET_ST05_PARAM_VALUES	Static method	Public	Method	get parameter values of ST05 trace for test execution	20080904
6	SET_ST05_PARAM_VALUES	Static method	Public	Method	set parameter values of ST05 trace for test execution	20080904

Events

Class CL_DB6_EXPLAIN_UTIL has no event.

Types

Class CL_DB6_EXPLAIN_UTIL has no local type.

Method Signatures

Method COLLECTPREDICATES Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	PREDICATES	Value transfer	☐	Type reference (TYPE)	STRING			20061220
2	Importing	XPL_INSTANCE	Call by reference	☐	Object reference (TYPE REF TO)	IF_DBA_EXPLAIN_INSTANCE		DBA EXPLAIN Model: EXPLAIN instance	20061220
3	Importing	XPL_NODE	Call by reference	☐	Object reference (TYPE REF TO)	IF_DBA_EXPLAIN_NODE		Explain node interface for JNet XML generation	20061220

Method COLLECTPREDICATES on class CL_DB6_EXPLAIN_UTIL has no exception.

Method COLLECTTABLES Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	PREDICATES	Call by reference	☐	Type reference (TYPE)	STRING			20061220
2	Returning	TABLE_LIST	Value transfer	☐	Type reference (TYPE)	STRING			20061220
3	Importing	XPL_INSTANCE	Call by reference	☐	Object reference (TYPE REF TO)	IF_DBA_EXPLAIN_INSTANCE		DBA EXPLAIN Model: EXPLAIN instance	20061220

Method COLLECTTABLES on class CL_DB6_EXPLAIN_UTIL has no exception.

Method GENERATEREALCARDSTATEMENT Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	STATEMENT	Value transfer	☐	Type reference (TYPE)	STRING			20070108
2	Importing	XPL_NODE	Call by reference	☐	Object reference (TYPE REF TO)	IF_DBA_EXPLAIN_NODE		Explain node interface for JNet XML generation	20070108

Method GENERATEREALCARDSTATEMENT on class CL_DB6_EXPLAIN_UTIL has no exception.

Method GENERATERETURNEDROWSSTATEMENT Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	STATEMENT	Value transfer	☐	Type reference (TYPE)	STRING			20061220
2	Importing	XPL_INSTANCE	Call by reference	☐	Object reference (TYPE REF TO)	IF_DBA_EXPLAIN_INSTANCE		DB6: Instance / Result of an EXPLAIN execution	20061220
3	Importing	XPL_NODE	Call by reference	☐	Object reference (TYPE REF TO)	IF_DBA_EXPLAIN_NODE		Explain node interface for JNet XML generation	20061220

Method GENERATERETURNEDROWSSTATEMENT on class CL_DB6_EXPLAIN_UTIL has no exception.

Method GET_ST05_PARAM_VALUES Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	PARAM_LIST	Value transfer	☐	Type reference (TYPE)	DB6XPLTEEX_TAB		DB6: List of St05 Parameters for Test Execute	20080904

Method GET_ST05_PARAM_VALUES on class CL_DB6_EXPLAIN_UTIL has no exception.

Method SET_ST05_PARAM_VALUES Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	PARAM_STRING	Call by reference	☐	Type reference (TYPE)	STRING			20080904

Method SET_ST05_PARAM_VALUES on class CL_DB6_EXPLAIN_UTIL has no exception.

History

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