SAP ABAP Class /SDF/CL_DB6_SQL_EXPL (Explain Plan)

Hierarchy

☛ ST-PI (Software Component) SAP Solution Tools Plug-In
   ⤷ SV-SMG-SDD (Application Component) Service Data Download
     ⤷ /SDF/DB6_INFR_7X (Package) Data Collectors for DB6 - OO

Properties

Class	/SDF/CL_DB6_SQL_EXPL
Short Description	Explain Plan
Super Class
Instantiability of a Class	2	Public
Final	☑

General Data

Message Class
Program status
Category	0
Package	/SDF/DB6_INFR_7X	Data Collectors for DB6 - OO
Created	20110118	SAP
Last change	20140121	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)

Interfaces

Class /SDF/CL_DB6_SQL_EXPL has no interface implemented.

Friends

Class /SDF/CL_DB6_SQL_EXPL has no friend class.

Attributes

#	Attribute	Level	Visibility	Read only	Typing	Associated Type	Initial Value	Description	Created on
1	ABAP_LINE	Instance attribute	Public	☐	See coding				20110119
2	ABAP_SOURCE	Instance attribute	Public	☐	See coding				20110119
3	ADBC_NAME	Instance attribute	Public	☐	Type reference (TYPE)	DBOBJECT_D		Table or index name	20110125
4	ADVISE_MODE	Instance attribute	Public	☐	Type reference (TYPE)	BOOLEAN		Boolean Variable (X=True, -=False, Space=Unknown)	20110125
5	BASIS_RL	Instance attribute	Public	☐	See coding				20110121
6	BASIS_SP	Instance attribute	Public	☐	See coding				20110121
7	CONNECTION	Instance attribute	Public	☐	Type reference (TYPE)	DBCON-CON_NAME		Logical name for a database connection	20110125
8	DBREL	Instance attribute	Public	☐	Type reference (TYPE)	DB6DBREL		DB6: DB2 UDB Release Level	20110125
9	DB_FIXPACK	Instance attribute	Public	☐	Type reference (TYPE)	I			20110123
10	DB_RELEASE	Instance attribute	Public	☐	See coding				20110123
11	EEE_FLAG	Instance attribute	Public	☐	Type reference (TYPE)	/SDF/DB6_700_XPLSTMT-DELETABLE			20110125
12	ERROR_SOURCE	Instance attribute	Public	☐	Type reference (TYPE)	/SDF/DB6_700_XPLINST-DB2_VERS			20110125
13	EXPLAIN_SCHEMA	Instance attribute	Public	☐	Type reference (TYPE)	DB6SCHEMA		DB6: Schema Name	20110125
14	EXPLAIN_TIME	Instance attribute	Public	☐	Type reference (TYPE)	CHAR26		Character field length 26	20110125
15	IXADVISOR_MODE	Instance attribute	Public	☐	Type reference (TYPE)	FLAG		General Flag	20110125
16	JAVA_SCHEMA_NAME	Instance attribute	Public	☐	Type reference (TYPE)	STRING			20110125
17	JAVA_SCHEMA_RETRIEVED	Instance attribute	Public	☐	Type reference (TYPE)	ABAP_BOOL			20110125
18	LT_ARGUMENT	Instance attribute	Public	☐	See coding				20110120
19	LT_DIAGNOSTICS	Instance attribute	Public	☐	See coding				20110121
20	LT_GRAPH	Instance attribute	Public	☐	See coding				20110914
21	LT_INSTANCE	Instance attribute	Public	☐	See coding				20110120
22	LT_OBJECT	Instance attribute	Public	☐	See coding				20110120
23	LT_OPERATOR	Instance attribute	Public	☐	See coding				20110120
24	LT_PREDICATE	Instance attribute	Public	☐	See coding				20110120
25	LT_PROGDIR	Instance attribute	Public	☐	See coding				20120224
26	LT_PROGDIR_INFO	Instance attribute	Public	☐	See coding				20120224
27	LT_STATEMENT	Instance attribute	Public	☐	See coding				20110120
28	LT_STREAM	Instance attribute	Public	☐	See coding				20110120
29	LT_SYSCOLUMNS	Instance attribute	Public	☐	See coding				20110120
30	LT_SYSINDCOLUSE	Instance attribute	Public	☐	See coding				20110121
31	LT_SYSINDEXES	Instance attribute	Public	☐	See coding				20110120
32	LT_SYSNODES	Instance attribute	Public	☐	See coding				20110120
33	LT_SYSTABLES	Instance attribute	Public	☐	See coding				20110120
34	LT_TABLE_FIELDS	Instance attribute	Public	☐	See coding				20110920
35	LT_TABLE_SETTINGS	Instance attribute	Public	☐	See coding				20110920
36	L_NEWOL	Instance attribute	Public	☐	Type reference (TYPE)	/SDF/DB6_700_XPLSTMT-UPDATABLE			20110125
37	L_NEWQD	Instance attribute	Public	☐	Type reference (TYPE)	/SDF/DB6_700_XPLPRED-HOW_APPLD			20110125
38	L_OPTHINT	Instance attribute	Public	☐	Type reference (TYPE)	STRING			20110125
39	L_REOPT	Instance attribute	Public	☐	Type reference (TYPE)	INT4		Natural number	20110125
40	L_SCHEMA	Instance attribute	Public	☐	Type reference (TYPE)	DB6SCHEMA		DB6: Schema Name	20110125
41	MY_L_T_ABAP_SRC	Instance attribute	Public	☐	See coding			Program information	20120224
42	NUM_EXECUTIONS	Instance attribute	Public	☐	See coding				20110118
43	OBJECT_NAME	Instance attribute	Public	☐	Type reference (TYPE)	/SDF/DB6_700_XPLOBJ-OBJ_NAME			20110125
44	OBJECT_SCHEMA	Instance attribute	Public	☐	Type reference (TYPE)	/SDF/DB6_700_XPLOBJ-OBJ_SCHEMA			20110125
45	OBJECT_TYPE	Instance attribute	Public	☐	Type reference (TYPE)	/SDF/DB6_700_XPLOBJ-OBJ_TYPE			20110125
46	OUTPUT_SQL_ERROR_NUMBER	Instance attribute	Public	☐	Type reference (TYPE)	SY-TABIX		Index of Internal Tables	20110125
47	OUTPUT_SQL_ERROR_TEXT	Instance attribute	Public	☐	Type reference (TYPE)	CHAR10		Character Field Length = 10	20110125
48	SCHEMA	Instance attribute	Public	☐	Object reference (TYPE REF TO)	DATA		Character field, length 32	20110118
49	STMT_ID	Instance attribute	Public	☐	Type reference (TYPE)	CHAR32		Character field, length 32	20110118
50	STMT_STR_TMP	Instance attribute	Public	☐	See coding				20110125
51	STMT_TEXT	Instance attribute	Public	☐	Type reference (TYPE)	STRING			20110118
52	SYS_DATA	Instance attribute	Public	☐	Type reference (TYPE)	DB6NAVSYST		DB6: System Registration Table	20110125
53	S_SOURCE	Instance attribute	Public	☐	Type reference (TYPE)	_S_SOURCE			20110119
54	T_ENV_INFO	Instance attribute	Public	☐	Type reference (TYPE)	_T_ENV_INFO			20110123

Methods

#	Method	Level	Visibility	Method type	Description	Created on
1	CONSTRUCTOR	Instance method	Public	Constructor	CONSTRUCTOR	20110118
2	EXECUTE_METHODS	Instance method	Public	Method	Execute relevant methods	20110125
3	GET_CATALOG_INFO	Instance method	Public	Method	Get catalog info of SQL statement objects	20110125
4	GET_EXPLAIN_TIMESTAMP	Instance method	Public	Method	Get SQL statement timestamp	20110125
5	GET_GRAPHICAL_EXPLAIN	Instance method	Public	Method	Get db2exfmt graphical output of explain plan	20110914
6	GET_JAVA_SCHEMA	Instance method	Public	Method	Get Java schema	20110125
7	GET_SOURCE_CODE_STMT	Instance method	Public	Method	Get ABAP source program and line number for SQL statements	20110119
8	GET_SOURCE_CODE_TXT	Instance method	Public	Method	Get ABAP source coding for SQL statements	20120223
9	READ_EXPLAIN_TABLES	Instance method	Public	Method	Fill Explain Tables for each SQL statement	20110125
10	RETRIEVE_ENV_INFO	Instance method	Public	Method	Get DB2 environment info	20110123

Events

Class /SDF/CL_DB6_SQL_EXPL has no event.

Types

#	Type	Visibility	Typing	Associated Type	Description	Created on	Type Source
1	_S_ENV_INFO	Public	See coding			20110123	BEGIN OF _s_env_info, num_dbpartitions TYPE i, inst_name TYPE c LENGTH 128, inst_ptr_size TYPE i, service_level TYPE c LENGTH 128, bld_level TYPE c LENGTH 128, ptf TYPE c LENGTH 128, fixpack_num TYPE i, END OF _s_env_info
2	_S_ERRORS	Public	See coding			20110118	BEGIN OF _s_errors, " for error handling sql_code TYPE i, sql_msg(250) TYPE c, END OF _s_errors
3	_S_SOURCE	Public	See coding			20110119	BEGIN OF _s_source, stmt_id TYPE char32, stmt_text TYPE string, abap_source(40) TYPE c, abap_line(8) TYPE c, END OF _s_source
4	_T_ENV_INFO	Public	See coding			20110123	_t_env_info TYPE STANDARD TABLE OF _s_env_info
5	_T_ERRORS	Public	See coding			20110118	_t_errors TYPE STANDARD TABLE OF _s_errors
6	_T_SOURCE	Public	See coding			20110119	_t_source TYPE STANDARD TABLE OF _s_source

Method Signatures

Method CONSTRUCTOR Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_CONNAME	Call by reference	☑	Type reference (TYPE)	DBCON_NAME		Logical name for a database connection	20110201
2	Importing	I_NUM_EXECUTIONS	Call by reference	☑	Type reference (TYPE)	P			20110118
3	Importing	I_STMTID	Call by reference	☑	Type reference (TYPE)	CHAR32		Character field, length 32	20110118
4	Importing	I_STMT_TEXT	Call by reference	☑	Type reference (TYPE)	STRING			20110118

Method CONSTRUCTOR on class /SDF/CL_DB6_SQL_EXPL has no exception.

Method EXECUTE_METHODS Signature

Method EXECUTE_METHODS on class /SDF/CL_DB6_SQL_EXPL has no parameter.

#	Exception	Resumable	Description	Created on
1	ADBC_ERROR	☐		20110125
2	SYSTEM_ERROR	☐		20110125

Method GET_CATALOG_INFO Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	OBJECT_NAME	Value transfer	☐	Type reference (TYPE)	/SDF/DB6_700_XPLOBJ-OBJ_NAME			20110127
2	Importing	OBJECT_SCHEMA	Value transfer	☐	Type reference (TYPE)	/SDF/DB6_700_XPLOBJ-OBJ_SCHEMA			20110127
3	Importing	OBJECT_TYPE	Value transfer	☑	Type reference (TYPE)	/SDF/DB6_700_XPLOBJ-OBJ_TYPE	'TA'		20110127

#	Exception	Resumable	Description	Created on
1	ADBC_ERROR	☐		20110125

Method GET_EXPLAIN_TIMESTAMP Signature

Method GET_EXPLAIN_TIMESTAMP on class /SDF/CL_DB6_SQL_EXPL has no parameter.

#	Exception	Resumable	Description	Created on
1	ADBC_ERROR	☐		20110127
2	SYSTEM_ERROR	☐		20110127

Method GET_GRAPHICAL_EXPLAIN Signature

Method GET_GRAPHICAL_EXPLAIN on class /SDF/CL_DB6_SQL_EXPL has no parameter.
Method GET_GRAPHICAL_EXPLAIN on class /SDF/CL_DB6_SQL_EXPL has no exception.

Method GET_JAVA_SCHEMA Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	SCHEMA_NAME	Value transfer	☐	Type reference (TYPE)	STRING			20110125

Method GET_JAVA_SCHEMA on class /SDF/CL_DB6_SQL_EXPL has no exception.

Method GET_SOURCE_CODE_STMT Signature

Method GET_SOURCE_CODE_STMT on class /SDF/CL_DB6_SQL_EXPL has no parameter.
Method GET_SOURCE_CODE_STMT on class /SDF/CL_DB6_SQL_EXPL has no exception.

Method GET_SOURCE_CODE_TXT Signature

Method GET_SOURCE_CODE_TXT on class /SDF/CL_DB6_SQL_EXPL has no parameter.
Method GET_SOURCE_CODE_TXT on class /SDF/CL_DB6_SQL_EXPL has no exception.

Method READ_EXPLAIN_TABLES Signature

Method READ_EXPLAIN_TABLES on class /SDF/CL_DB6_SQL_EXPL has no parameter.

#	Exception	Resumable	Description	Created on
1	ADBC_ERROR	☐		20110127
2	SYSTEM_ERROR	☐		20110127

Method RETRIEVE_ENV_INFO Signature

Method RETRIEVE_ENV_INFO on class /SDF/CL_DB6_SQL_EXPL has no parameter.
Method RETRIEVE_ENV_INFO on class /SDF/CL_DB6_SQL_EXPL has no exception.

History

Last changed by/on	SAP	20140121
SAP Release Created in	2008_1_700