zOs/SQL/CATV9NES

set current sqlid = 'A540769';
select * from s100447.db2v9ts
    where dbName = 'DGDB9998' and v9 <> ''
;
delete from plan_table where queryno = 222;
-- explain plan set queryno = 222 for
select tp, char(left(nm, 40), 40), v9 from s100447.db2v9
    where v9 <> ''
      and (    ( cr = 'GDB9998' and tb = 'TWK573A1' )
            or ( cr = 'GDB9998' and tb = 'TWK574A1' )
            or ( cr = 'GDB9998' and tb = 'TWK575A1' )
            or ( cr = 'GDB9998' and tb = 'TWK576A1' )
            or ( cr = 'GDB9998' and tb = 'TWK135A1' )
            or ( cr = 'GDB9998' and tb = 'TWK145A1' )
          )
    order by cr, tb, cl
;

select * from plan_view5a
    where queryno in ( 111, 222)
    order by applname, progname, queryNo, qblockno, planno
;
where (dbName = 'CT02A1A' and name = 'TCT170A1')
  or  (dbName=  'RP01A1A' and name in ('TRP161A1',
                            'TRP162A1',
                            'TRP163A1')
      )
;
x
selectdeclare global temporary table session.gtt1
from s100447.db2v9 v
    where v9 <> ''   --and db = 'DGDB9998'
    order by cr, tb, cl
;
x
select tp, char(nm, 30), v9 from s100447.db2v9ts where v9 <> '';
select tp, char(nm, 30), v9 from s100447.db2v9tb where v9 <> '';
select tp, char(nm, 30), v9 from s100447.db2v9cl where v9 <> '';
select tp, char(nm, 30), v9 from s100447.db2v9ix where v9 <> '';