zOs/SQL/CATV9NET

set current sqlid = 'A540769';
delete from plan_table where queryno = 111
;
--explain plan set queryno = 111 for
select tp, char(left(nm, 40), 40), v9, v.*
    from s100447.db2v9 v
    where (    ( 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' )
            or ( cr = 'GDB9998' and tb = 'TWK145A1' )
            or ( cr = 'GDB9998' and tb = 'TWK145A1' )
            or ( cr = 'GDB9998' and tb = 'TWK145A1' )
            or ( cr = 'GDB9998' and tb = 'TWK145A1' )
            or ( cr = 'GDB9998' and tb = 'TWK145A1' )
          )
;
select * from plan_view5a
    where queryno in ( 111, 222)
    order by applname, progname, queryNo, qblockno, planno
;
rollback;