Estimated rows selected and query join information

  ID    Name         Type              Description
  2042  QQREST       BIN(32)           Estimated number of rows to be retrieved.
  2044  QQAJN        BIN(32)           Estimated number of joined rows to be
                                       retrieved.
  2046  QQJNP        BIN(32)           Join position of the table queried.
  2048  QQJNDS       BIN(32)           Table data number of the table queried.
  2050  QQJNMT       CHAR(2)           Join method. Possible options are:
                                       NL - Nested loop
                                       MF - Nested loop with selection
                                       HJ - Hash join
  2052  QQJNTY       CHAR(2)           Join type. Possible values are:
                                       IN - Inner join
                                       PO - Left partial outer join
                                       EX - Exception join
  2054  QQJNOP       CHAR(2)           Join operator. Possible values are:
                                       EQ - Equal
                                       NE - Not equal
                                       GT - Greater than
                                       GE - Greater than or equal
                                       LT - Less than
                                       LE - Less than or equal
                                       CP - Cartesian product
  2056  QVJFANO      CHAR(1)           Type of join fan-out. Possible values are:
                                       N - Normal join situation where join fan-out
                                           is allowed and each matching row of the
                                           join fan-out is returned.
                                       D - Distinct fan-out. Join fan-out is allowed;
                                           however, none of the join fan-out rows
                                           are returned.
                                       U - Unique fan-out. Join fan-out is not allowed.
                                           Error situation if join fan-out occurs.
  2058  QVFILES      BIN(32)           Number of tables joined together.
  2070  QVBNDY       CHAR(1)           Indicates if the query is I/O or CPU bound.
                                       Possible values are:
                                       I - I/O bound.
                                       C - CPU bound.
  2080  QQRCOD       CHAR(2)           Reason code for current operation.