zOs/SQL/BINDDBP

select length(errMsg), length(strip(errMsg)), g.*
  from oa1p.tQZ043BindGen g order by restst desc
;x;
insert into oa1p.tQz040BindPgm values ('AURA', 'YAUCORC', '10.02.2014');
select * from oa1p.vQz040BindDBP
    order by pgm, appl, install, rdlSeq, cqSeq, ovSeq
;
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
;
select * from oa1p.vQz040BindGrp
    order by appl, pgm, install, rdlSeq, cqSeq
;
select * from oa1p.vQz040Bind
    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.vQz040BindDBP
    where rz = 'RZ1'
    order by pgm, appl, install, rdlSeq, cqSeq, ovSeq
;x;