zOs/SQL/OPTHISIO

set current sqlid = 'A540769';
delete from A540769.plan_table;
delete from A540769.dsn_userquery_table;
insert into A540769.plan_table
  select *
      from cmnbatch.plan_table
   -- from cmnbatch.plan_view2Det
      where     collid     = 'BP'
          and progName     = 'YBPSUCH'
          and explain_time = '2014-04-20-03.58.20.271427'
          and queryno = 713
  ;
-- insert opthint text and options
INSERT INTO DSN_USERQUERY_TABLE
    ( QUERYNO, SCHEMA, HINT_SCOPE,
      QUERY_TEXT,
      REOPT
    )
    SELECT 713, p.qualifier, 0, -- 0=system, 1=package
        s.STATEMENT,
        'Y'
    from sysibm.sysPackStmt s
      join sysibm.sysPackage p
        on s.location = p.location and s.collid = p.collid
          and s.name = p.name
          and s.version = p.version and s.contoken = p.contoken
    where s.location  ='' and s.collid = 'BP' and s.name = 'YBPSUCH'
          and s.version = 'BPST000070594A877D'
          and s.queryno = 713
;
commit
;
select * from plan_view1;
select * from dsn_userquery_table;
;x
;x;
select * from sysibm.sysQuery
;
select p.qualifier, s.statement
    from sysibm.sysPackStmt s
      join sysibm.sysPackage p
        on s.location = p.location and s.collid = p.collid
          and s.name = p.name
          and s.version = p.version and s.contoken = p.contoken
    where s.location  ='' and s.collid = 'BP' and s.name = 'YBPSUCH'
          and s.version = 'BPST000070594A877D'
          and s.queryno = 713
;
-- -dsn BIND QUERY EXPLAININPUTSCHEMA( A540769 )
;x;
-- insert opthint text and options