zOs/SQL/BINDXRI
with j as
(
select p.rdl pRdl, c.key cKey
from OA1P.tAdm41bindParm p
full join (select * from OA1P.tAdm42bindCnfg where typ = 'rdl') c
on c.key = p.rdl
)
select * from j
where pRdl is null or cKey is null
;
with j as
(
select p.cq pcq , c.key cKey
from OA1P.tAdm41bindParm p
full join (select * from OA1P.tAdm42bindCnfg where typ = 'cq') c
on c.key = p.cq
)
select * from j
where pcq is null or cKey is null
;
with j as
(
select p.ov pOv , c.key cKey
from OA1P.tAdm41bindParm p
full join ( select * from OA1P.tAdm42bindCnfg where typ = 'ov') c
on c.key = p.ov
)
select * from j
where pov is null or cKey is null