SAP Function STU3_EXPLAIN_SQL - Explains and displays the access path of an SQL statement

Parameter Reference Type Length Default Optional Text
CALLED_BY_DBACOCKPIT C C 0 X Specifies if this function has been called by the DBACOCKPIT
DB_CONNECTION DBCON-CON_NAME C 30 X Logical name for a database connection
EXPERT_MODE I I 4 0 X Display expert mode?
EXPLAIN_STMT C C 0 X SQL statement text
NO_DISPLAY C C 0 X Single-character flag
PERFORM_EXPLAIN I I 4 0 X Perform Explain within function?
STMT_DATE DATS D 8 X Date for historical view
STMT_ID I I 4 X Statement ID from DSC
STMT_MSEC DB2EVTTMS C 6 X Msec for historical view
STMT_TIME TIMS T 6 X Time for historical view in UTC
STMT_TOKEN C C 0 X

Parameter Reference Type Length Text
SQL_CODE I I 4 SQL code of explain statement ID

Parameter Reference Length Optional Text
PLAN EXPL_PLAN 133 X Access Plan Output Line (FB RS_EXPLAIN_PLAN...)