zOs/SQL/BIPA9LT1

select *
  from            oa1p.bind_parameters
  where opthint <> ''
  ;
select *
  from            oa1p.bind_exceptions_log
--where qualifier  <> 'BUA' and qualifier not like 'OA1$%'
--where pgm = 'AU5070' or pgm like 'YAU030%'
  where pgm = 'YCDPUT2'
  order by pgm, mod_ts
  ;x;
select qualifier,  count(*)
  from            oa1p.bind_parameters p
  group by qualifier
  ;x;
select
  e.ssid,e.location,e.collid,e.qualifier,
  p.appl,p.pgm,p.collid,p.installdate
  from            oa1p.bind_parameters p
  left outer join oa1p.bind_exceptions e
  on  e.appl   = p.appl
  and e.pgm    = p.pgm
  and e.collid = p.collid
  and e.installdate  = p.installdate
  where p.pgm = 'YAU019U'
    and (e.ssid= 'DBAF' or e.ssid is NULL)
;
select
  e.ssid,e.location,e.collid,e.qualifier,
  p.appl,p.pgm,p.collid,p.installdate
  from            oa1p.bind_parameters p
  left outer join oa1p.bind_exceptions e
  on  e.appl   = p.appl
  and e.pgm    = p.pgm
  and e.collid = p.collid
  and e.installdate  = p.installdate
    and  e.ssid= 'DBAF'
  where p.pgm = 'YAU019U'