SAP ABAP Function Module STU3_GET_SINGLE_SQL_STATS (Retrieves SQL statistics for a single statement)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DB-DB2 (Application Component) DB2 for z/OS
     ⤷ STU3 (Package) Development Class for Database Monitor

Basic Data

Function Module	STU3_GET_SINGLE_SQL_STATS	Retrieves SQL statistics for a single statement
Function Group	STU3	FM for DB2/390 DB monitor
Program Name	SAPLSTU3
INCLUDE Name	LSTU3U04

Parameters

Type	Parameter Name	Typing	Associated Type	Default value	Optional	Pass Value	Short text
Changing	CON_REF	TYPE REF TO	CL_SQL_CONNECTION		☑	☑	Database Connection
Exporting	SQL_STATS	TYPE	DB2QSTC		☐	☑	Structure for Statement Trace
Exporting	SQL_LONG	TYPE	DB2SQLLONG		☐	☑	Contains long SQL statement texts
Importing	DB2_MEMBER	TYPE	DB2MEMN		☑	☑	DB2 member name in data sharing environment
Importing	SQL_TOKEN	TYPE	DB2QSTTOKN		☑	☑	Statement ID
Importing	REMOTE_DB_CON	TYPE	DBCON-CON_NAME		☑	☑	Logical name for a database connection
Importing	PREFETCHED_STATS	TYPE	CHAR01		☑	☑	Character Field Length 1
Importing	ALERT_STATS	TYPE	CHAR01		☑	☑	Character Field Length 1
Importing	DO_NOT_CLOSE_CON	TYPE	CHAR01		☑	☑	Character Field Length 1
Tables	SQL_TEXT	TYPE	LINETAB		☑	☐	Structure for 72 Character Line
Tables	PREP_ATTRIBUTES	TYPE	LINETAB		☑	☐	Structure for 72 Character Line
Exception	ADBC_SQL_ERROR	TYPE			☐	☐

Processing Type

☑ Normal Function Module
☐ Remote-Enabled Module	☐ BaseXML supported
☐ Update Module	☑ Start immediately
	☐ Immediate Start, No Restart
	☐ Start Delayed
	☐ Coll.run
☐ JAVA Module Callable from ABAP
☐ Remote-Enabled JAVA Module
☐ Module Callable from JAVA

History

Last changed by/on	SAP	20050302
SAP Release Created in