Information about the SQL statement being
executed
ID Name Type
Description
1220
QQSTN
BIN(32) Statement
number (unique per statement)
1222 QQSTF
CHAR(1) Statement
function. Possible values are:
S - Select
U - Update
I - Insert
D - Delete
L - Data Definition Language
O - Other
1224 QQSTOP
CHAR(2) Statement
operation. Possible values are:
AL - Alter Table
CA - Call
CL - Close
CO - Comment On
CM - Commit
CN - Connect
CC - Create Collection
CI - Create Index
CT - Create Table
CV - Create View
DP - Declare Procedure
DL - Delete
DE - Describe
DT - Describe Table
DI - Distinct
DR - Drop
EX - Execute
EI - Execute Immediate
FE - Fetch
GR - Grant
IN - Insert
LO - Label On
LK - Lock
OP - Open
PR - Prepare
RE - Release
RV - Revoke
RO - Rollback
SI - Select Into
SC - Set Connection
ST - Set Transaction
UP - Update
GR - Grant
GR - Grant
1226 QQSTTY
CHAR(1) Statement
type. Possible values are:
D - Dynamic Statement
S - Static Statement
1228 QQSNAM
CHAR(18) Name to the SQL
statement.
1230 QQSTOC
CHAR(1) Statement
outcome. Possible values are:
S - Success
F - Fail
1232 QVSQCOD
BIN(32) SQL Return
Code.
1232
QVSQST
CHAR(8)
SQLSTATE.
1232 QQCNAM
CHAR(18) Name of the
cursor corresponding to this
SQL statement, if applicable.
1240 QQPNAM
CHAR(10) Name of package
or name of program that
contains the SQL statement.
1242 QQPLIB
CHAR(10) Name of the
schema containing the package.
1244 QQROWR
BIN(32) Number of
result rows returned.
1246 QQROWF
BIN(32) Total rows
fetched for cursor.
1248 QQSTTX
VARCHAR(1000) Statement text.