Additional information about the SQL statement being executed

    ID    Name         Type              Description
  1306  QVCLSCR      CHAR(10)          CLOSQLCSR setting. Possible values are:
                                       *ENDJOB - SQL cursors are closed when the
                                                 job ends.
                                       *ENDMOD - SQL cursors are closed when the
                                                 module ends.
                                       *ENDPGM - SQL cursors are closed when the
                                                 program ends.
                                       *ENDSQL - SQL cursors are closed when the
                                                 first SQL program on the call
                                                 stack ends.
                                       *ENDACTGRP - SQL cursors are closed when
                                                 the activation group ends.
  1308  QVALWCY      CHAR(1)           ALWCPYDTA setting. Possible values are:
                                       N - temporary tables allowed
                                       Y - Temporary copy of the data is allowed
                                           only if necessary to execute the query.
                                       O - Temporary copy of the data may be used
                                           if the query optimizer determines it
                                           is cost effective to do so.
  1310  QVPSUDO      CHAR(1)           Pseudo open.
                                                                             Y - Yes
                                       N - No
  1312  QVPSUDC      CHAR(1)           Pseudo close.
                                                                              Y - Yes
                                       N - No
  1314  QVODPI       CHAR(1)           ODP implementation. Possible values are:
                                       R - Reusable ODP
                                       N - Nonreusable ODP
                                       . . - Not used
  1320  QVDYNR       CHAR(2)           Dynamic replan reason code. Possible
                                       values are:
                                       NA - No replan.
                                       NR - SQL QDT rebuilt for new release.
                                       A1 - A table or member is not the same
                                            object as the one referenced when
                                            the access plan was last built. Some
                                            reasons they could be different are:
                                            - Object was deleted and recreated.
                                            - Object was saved and restored.
                                            - Schema list was changed.
                                            - Object was renamed.
                                            - Object was moved.
                                            - Object was overridden to a
                                              different object.
                                            - This is the first run of this
                                              query after the object containing
                                              the query has been restored.
                                       A2 - Access plan was built to use a
                                            reusable Open Data Path (ODP) and the
                                            optimizer chose to use a non-reusable
                                            ODP for this call.
                                       A3 - Access plan was built to use a
                                            non-reusable Open Data Path (ODP) and
                                            the optimizer chose to use a reusable
                                            ODP for this call.
                                       A4 - The number of rows in the table
                                            has changed by more than 10% since
                                            the access plan was last built.
                                       A5 - A new index exists over one of the
                                            tables in the query.
                                       A6 - An index that was used for this access
                                            plan no longer exists or is no longer
                                            valid.
                                       A7 - OS/400 Query requires the access plan
                                            to be rebuilt because of system
                                            programming changes.
                                       A8 - The CCSID of the current job is
                                            different than the CCSID of the job
                                            that last created the access plan.
                                       A9 - The value of one or more of the
                                            following is different for the
                                            current job than it was for the
                                            job that last created this access
                                            plan:
                                            - date format.
                                            - date separator.
                                            - time format.
                                            - time separator.
                                       AA - The sort sequence table specified
                                            is different than the sort sequence
                                            table that was used when this
                                            access plan was created.
                                       AB - Storage pool changed or DEGREE
                                            parameter of the Change Query Attributes (CHGQRYA)
                                            command changed.
                                       AC - The system feature DB2 Multisystem
                                            has been installed or removed.
                                       AD - The value of the degree query
                                            attribute has changed.
                                       AE - A view is either being opened by a
                                            high level language or a view is
                                            being materialized.
                                       AF - A User-Defined Type (UDT) or a User-Defined
                                            Function (UDF) is not the same object as
                                            the one referred to in the access
                                            plan.
                                       B0 - The options specified have changed
                                            as a result of the query options
                                            File.
  1324  QVDYNSC      CHAR(2)           Dynamic replan subtype reason code.
  1326  QVDYNRT      Z                 Timestamp of when the access plan was
                                       last rebuilt.
  1330  QQPARS       CHAR(1)           Parse required.
                                                                              Y - Yes
                                       N - No
  1332  QQDACV       CHAR(1)           Data Conversion. If greater than 0, some columns
                                       were mapped or converted during execution
                                       of the query. Because the columns were converted
                                       their attributes may no longer match the
                                       attributes of the key column of the index
                                       expected to be used. If the attributes
                                       do not match the index can not be used.
                                       Reasons why the data was converted are:
                                       N - No.
                                       0 - Not applicable.
                                       1 - Lengths do not match.
                                       2 - Numeric types do not match.
                                       3 - C host variable is NULL-terminated
                                       4 - Host variable or column is
                                           variable length and the other
                                           is not variable length.
                                       5 - CCSID conversion.
                                       6 - DRDA and NULL capable, variable
                                           length, contained in a partial
                                           row, derived expression, or
                                           blocked fetch with not enough
                                           host variables.
                                       7 - Data, time, or timestamp column.
                                       8 - Too many host variables.
                                       9 - Target table of an insert is
                                           not an SQL table.
  1334  QVCMMT       CHAR(4)           Level of commitment control.
                                       NC - No commit
                                       UR - Uncommitted read
                                       CS - Cursor stability
                                       CSKL - Cursor stability, keep lock
                                       RS - Read stability
                                       RR - Repeatable read
  1336  QVBLKE       CHAR(1)           Blocking enabled.
                                                                            Y - Yes
                                       N - No
  1338  QVDLYPR      CHAR(1)           Delay prep.
                                                                              Y - Yes
                                       N - No
  1340  QVNAMC       CHAR(1)           Naming convention used. Possible values are:
                                       S - SQL naming convention
                                       N - System naming convention
  1342  QVDYNTY      CHAR(1)           Type of Dynamic. Possible values are:
                                       E - Extended dynamic
                                       S - System wide cache
                                       L - Local prepared statement
  1344  QVOLOB       CHAR(1)           Optimize LOB data types.
                                                                              Y - Yes
                                       N - No
  1350  QVUSRP       CHAR(10)          User profile used when compiled program
                                       object is executed.
  1352  QVDUSRP      CHAR(10)          User profile used for dynamic SQL
                                       statements.
  1354  QVDFTCL      CHAR(128)         Name of the default collection.
  1360  QVPROCN      CHAR(128)         Procedure name on CALL to SQL.
  1362  QVPROCL      CHAR(128)         Procedure schema on CALL to SQL.
  1364  QVSPATH      VARCHAR(1000)     Path to be used to find procedures,
                                       functions, and user-defined types for
                                       static SQL statements.