zOs/SQL/BINDBIND

insert into oa1p.tQZ040BindPgm
     values ('KUGE', 'YCDUVGA', '31.12.2014', 7, 'info yQuCorc');
select * from oa1p.vQZ040Bind
    order by pgm, appl, install, rdlSeq, cqSeq, ovSeq ;
select * from oa1p.vQZ040BindRz
    order by pgm, appl, install, rdlSeq, cqSeq, ovSeq ;
;x;
insert into oa1p.tQZ040BindPgm
     values ('AURA', 'YCDSGET', current date, 7, 'info yQuCorc');
insert into oa1p.tQZ040BindPgm -- (appl, pgm, install)
    values ('nnn', 'YCDCCFG', '08.08.2014', 9, 'info 9 yavvdps ....');
select * from oa1p.vQZ040BindDBP
    order by pgm, appl, install, rdlSeq, cqSeq, ovSeq ;
select * from oa1p.vQZ040ReBind
    order by pgm, appl, install, rdlSeq, cqSeq, ovSeq ;
;x;
insert into oa1p.tQZ040BindPgm
     values ('AURA', 'YAUCORC', current date, 7, 'info yQuCorc');
insert into oa1p.tQZ040BindPgm -- (appl, pgm, install)
    values ('nnn', 'YAVVDPS', '01.04.2014', 9, 'info 9 yavvdps ....');
select * from oa1p.vQZ040Bind
    order by pgm, appl, install, rdlSeq, cqSeq, ovSeq ;
select * from oa1p.vQZ040BindRz
    order by pgm, appl, install, rdlSeq, cqSeq, ovSeq ;
select * from oa1p.vQZ040BindDBP
    order by pgm, appl, install, rdlSeq, cqSeq, ovSeq ;
select * from oa1p.vQZ040ReBind
    order by pgm, appl, install, rdlSeq, cqSeq, ovSeq ;
;x;
select * from oa1p.tQZ040BindPgm;
select * from oa1p.vQZ040BindPgm;
select * from oa1p.VQZ040BINDRDL;
select * from oa1p.vQZ040BindDBP;
select * from oa1p.vQZ040reBind
    order by pgm, appl, install, rdlSeq, cqSeq, ovSeq ;
 -- where rz = 'RZ1'
;
select * from oa1p.vQZ040Bind
 -- where rz = 'RZ1'
    order by pgm, appl, install, rdlSeq, cqSeq, ovSeq
;x;
select * from oa1p.vQZ040BindPgm
    order by appl, pgm, install
;
select * from oa1p.vQZ040BindRDL
    order by appl, pgm, install, rdlSeq
;
select * from oa1p.vQZ040BindCQ
    order by appl, pgm, install, rdlSeq, cqSeq
;
select * from oa1p.vQZ040BindOV
    order by appl, pgm, install, rdlSeq, cqSeq, ovSeq
;x;
insert into oa1p.tQZ040BindPgm values ('MF', 'MF5000', current date);
insert into oa1p.tQZ040BindPgm values ('ELAR', 'ELA1', current date);
insert into oa1p.tQZ040BindPgm values ('AURA', 'YAUCORC', current date);
insert into oa1p.tQZ040BindPgm values ('nnn', 'YCDSGET', current date);
insert into oa1p.tQZ040BindPgm values ('nnn', 'YYWM05E', current date);
insert into oa1p.tQZ040BindPgm values ('nnn', 'YAVVDPS', '01.01.2013');
insert into oa1p.tQZ040BindPgm values ('nnn', 'YNILCTG', '10.02.2014');
select * from oa1p.vQZ040Bind
    where rz = 'RZ1'
    order by pgm, appl, install, rdlSeq, cqSeq, ovSeq
;x;