Environmental information about the SQL statement
executed
ID Name Type
Description
8014
QVPSIZ
BIN(32) Memory pool
size.
8016
QVPID
BIN(32) Memory pool
ID.
8020
QVDFMT
CHAR(3) Date format
used.
8022
QVDSEP
CHAR(1) Date
separator used.
8024 QVTFMT
CHAR(3) Time format
used.
8026
QVTSEP
CHAR(1) Time
separator used.
8028 QVDPNT
CHAR(1) Decimal
point used.
8030 QVSRTSQ
CHAR(10) Sort Sequence
table name, if used.
8032 QVSRTSL
CHAR(10) Sort Sequence
schema, if used.
8034 QVLNGID
CHAR(3) Language ID
used.
8036
QVCNTID
CHAR(2) ID
used for country or region.
8040
QVINIT
CHAR(10) Query options
file name.
8042 QVINIL
CHAR(10) Query options
file schema.
8044 QVMAXT
BIN(32) Query time
limit, max run time, in seconds.
8046 QVPARA
BIN(32) Parallel
options setting.
8048 QVTASKN
BIN(32) Maximum
number of tasks to use for parallel SMP.
8050 QVAPLYR
CHAR(1) Apply
CHGQRYA options remotely.
Y - Yes
N - No
8052
QVASYNC
CHAR(10) Asynchronous job
usage for remote nodes.
8054 QVFRCJ
CHAR(1) Join order
was forced.
Y - Yes
N - No
8056
QVDMSGS
CHAR(1) Display
DEBUG messages.
Y - Yes
N - No
8060
QVPMCNV
CHAR(1) Using
parameter marker conversion.
Y - Yes
N - No
8062
QVUDFTL
BIN(32) UDF time
limit.
8064
QVOLMTS
CHAR(128) Specified optimizer
limitations.