db2 call sysproc.am_get_rpt(-2, 21, 'auth_id=''DB2FP9A'' and appl_name=''db2bp''', 5)
 結果セット 1
  --------------
  STMT_TEXT
 AVERAGE_STMT_EXEC_TIME TOTAL_EXEC_TIME      NUM_EXECUTIONS       TOTAL_USR_CPU_TIME
 TOTAL_SYS_CPU_TIME   ROWS_READ            ROWS_WRITTEN         STMT_SORTS           NUM_COMPILATIONS     PREP_TIME_BEST
       PREP_TIME_WORST      INT_ROWS_INSERTED    INT_ROWS_UPDATED     INT_ROWS_DELETED
  ----------------------------------------------------------------------------------------------------------------------
 select l_orderkey, sum(l_extendedprice * (1 - l_discount)) as revenue, o_orderdate, o_shippriority from tpcd.customer,
 tpcd.orders, tpcd.lineitem where c_mktsegment = 'BUILDING' and c_custkey = o_custkey and l_orderkey = o_orderkey and o_
orderdate < date ('1995-03-15') and l_shipdate > date ('1995-03-15') and l_shipmode = 'RAIL' group by l_orderkey, o_orde
rdate, o_shippriority order by revenue desc, o_orderdate fetch first 10 rows only
 123                 1107                    9                  289
                   21             56411906              3732712                   33                    1
    43                   43                    0                    0                    0