zOs/WK/OPTHIQUI
-- insert row into dsn_userQuery_table
-- query_text from sysPackStmt
--
set current sqlid = 'A540769';
delete from A540769.plan_table;
delete from A540769.DSN_STATEMNT_TABLE;
delete from A540769.DSN_DetCost_TABLE ;
delete from A540769.dsn_filter_Table ;
delete from A540769.dsn_predicat_table;
delete from A540769.dsn_userquery_table;
INSERT INTO DSN_USERQUERY_TABLE
( QUERYNO, SCHEMA, HINT_SCOPE
, QUERY_TEXT
)
SELECT 70, p.qualifier, 0, -- 0=system, 1=package
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
;