zOs/SQL/OPTHINCO

INSERT INTO CMNBATCH.PLAN_TABLE (
        "QUERYNO"
      , QBLOCKNO
      , APPLNAME
      , PROGNAME
      , PLANNO
      , METHOD
      , CREATOR
      , TNAME
      , TABNO
      , ACCESSTYPE
      , MATCHCOLS
      , ACCESSCREATOR
      , ACCESSNAME
      , INDEXONLY
      , SORTN_UNIQ
      , SORTN_JOIN
      , SORTN_ORDERBY
      , SORTN_GROUPBY
      , SORTC_UNIQ
      , SORTC_JOIN
      , SORTC_ORDERBY
      , SORTC_GROUPBY
      , TSLOCKMODE
      , TIMESTAMP
      , REMARKS
      , PREFETCH
      , COLUMN_FN_EVAL
      , MIXOPSEQ
      , VERSION
      , COLLID
      , ACCESS_DEGREE
      , ACCESS_PGROUP_ID
      , JOIN_DEGREE
      , JOIN_PGROUP_ID
      , SORTC_PGROUP_ID
      , SORTN_PGROUP_ID
      , PARALLELISM_MODE
      , MERGE_JOIN_COLS
      , CORRELATION_NAME
      , PAGE_RANGE
      , JOIN_TYPE
      , GROUP_MEMBER
      , IBM_SERVICE_DATA
      , WHEN_OPTIMIZE
      , QBLOCK_TYPE
      , BIND_TIME
      , OPTHINT
      , HINT_USED
      , PRIMARY_ACCESSTYPE
      , PARENT_QBLOCKNO
      , TABLE_TYPE
      , TABLE_ENCODE
      , TABLE_SCCSID
      , TABLE_MCCSID
      , TABLE_DCCSID
      , ROUTINE_ID
      , CTEREF
      , STMTTOKEN
   ) select
        QUERYNO
      , QBLOCKNO
      , APPLNAME
      , PROGNAME
      , PLANNO
      , METHOD
      , CREATOR
      , TNAME
      , TABNO
      , ACCESSTYPE
      , MATCHCOLS
      , ACCESSCREATOR
      , ACCESSNAME
      , INDEXONLY
      , SORTN_UNIQ
      , SORTN_JOIN
      , SORTN_ORDERBY
      , SORTN_GROUPBY
      , SORTC_UNIQ
      , SORTC_JOIN
      , SORTC_ORDERBY
      , SORTC_GROUPBY
      , TSLOCKMODE
      , TIMESTAMP
      , REMARKS
      , PREFETCH
      , COLUMN_FN_EVAL
      , MIXOPSEQ
      , 'A18Q002827' --        VERSION
      , COLLID
      , ACCESS_DEGREE
      , ACCESS_PGROUP_ID
      , JOIN_DEGREE
      , JOIN_PGROUP_ID
      , SORTC_PGROUP_ID
      , SORTN_PGROUP_ID
      , PARALLELISM_MODE
      , MERGE_JOIN_COLS
      , CORRELATION_NAME
      , PAGE_RANGE
      , JOIN_TYPE
      , GROUP_MEMBER
      , IBM_SERVICE_DATA
      , WHEN_OPTIMIZE
      , QBLOCK_TYPE
      , current timestamp -- BIND_TIME
      , 'WK1' -- OPTHINT
      , HINT_USED
      , PRIMARY_ACCESSTYPE
      , PARENT_QBLOCKNO
      , TABLE_TYPE
      , TABLE_ENCODE
      , TABLE_SCCSID
      , TABLE_MCCSID
      , TABLE_DCCSID
      , ROUTINE_ID
      , CTEREF
      , STMTTOKEN
    from CMNBATCH.PLAN_TABLE
--  where progName = 'RI0810'    and timestamp > '200802'
--        and queryNo   =    3974
        where progname = 'RI0810'
        and bind_time = '2008-02-09-00.39.32.954891'
        and Queryno = 3974
    ;
select * from cmnBatch.plan_table
     where optHint = 'WK1'
    ;
commit
;
    ,