Information about the temporary table created

    ID    Name         Type              Description
  2510  QQTMPR       BIN(32)           Number of rows in table created.
  2512  QVTTSIZ      BIN(32)           Size, in bytes, of table created.
  2514  QVTTRSZ      BIN(32)           Row size, in bytes, of table created.
  2516  QQDFVL       CHAR(1)           Default values in table created.
                                                                              Y - Yes
                                       N - No
  2518  QVTTRST      CHAR(1)           Temporary result table created.
                                                                              Y - Yes
                                       N - No
  2520  QVTDSTB      CHAR(10)          Distributed table created.
                                                                              Y - Yes
                                       N - No
  2522  QVTNODS      CHAR(10)          Nodes of distributed table created.
  2524  QVTTRC       CHAR(2)           Reason code why temporary table was
                                       created. Possible values are:
                                       F1 - Query contains grouping columns
                                            (GROUP BY) from more that one
                                            table, or contains grouping
                                            columns from a secondary table
                                            of a join query that cannot be
                                            reordered.
                                       F2 - Query contains ordering columns
                                            (ORDER BY) from more that one
                                            table, or contains ordering
                                            columns from a secondary table
                                            of a join query that cannot be
                                            reordered.
                                       F3 - The grouping and ordering
                                            columns are not compatible.
                                       F4 - DISTINCT was specified for the
                                            query.
                                       F5 - UNION was specified for the query.
                                       F6 - Query had to be implemented
                                            using a sort.  Key length of
                                            more than 2000 bytes or more
                                            than 120 key columns specified
                                            for ordering.
                                       F7 - Query optimizer chose to use a
                                            sort rather than an index to order
                                            the results of the query.
                                       F8 - Perform specified row selection
                                            to minimize I/O wait time.
                                       F9 - The query optimizer chose to use a
                                            hashing algorithm rather than an
                                            index to perform the grouping.
                                       FA - The query contains a join condition
                                            that requires a temporary file.
                                       H1 - Table is a join logical file and its
                                            join type does not match the join
                                            type specified in the query.
                                       H2 - Format specified for the
                                            logical table references more
                                            than one base table.
                                       H3 - Table is a complex SQL view
                                            requiring a temporary table to
                                            contain the the results of the
                                            SQL view.
                                       H4 - For an update-capable query, a
                                            subselect references a column in
                                            this table which matches one of the
                                            columns being updated.
                                       H5 - For an update-capable query, a
                                            subselect references an SQL view
                                            which is based on the table being
                                            updated.
                                       H6 - For a delete-capable query, a
                                            subselect references either:
                                            - the table from which rows are to
                                              be deleted
                                            - an SQL view, or
                                            - an index based on the table from
                                              which rows are to be deleted