zOs/SQL/CATPKGMG

select *
    from sysibm.sysPackage
    where name = 'YRMVER'
;
select *
    from sysibm.sysPackCopy
    where name = 'YRMVER'
;;
with dt as
(
select dLOCATION, dCollid, dName, dContoken
       ,  max(translate(dType, 's ', '  NTOP', ' ')) --' ' normal
       || max(translate(dType, 'N ', 'N NTOP', ' ')) --NativeSqlRoutine
       || max(translate(dType, 'T ', 'T NTOP', ' ')) --Trigger
       || max(translate(dType, 'O ', 'O NTOP', ' ')) --Original
       || max(translate(dType, 'P ', 'P NTOP', ' ')) --Previous
       || max(translate(dType, '  ', '  NTOP', ' ')) --any others?
          dTypes
    from sysibm.sysPackDep
 -- where dLocation = '' and dcollid = 'MF' and dname like 'MF5%'
    group by dLocation, dCollid, dName, dContoken
)
select  dTypes, count(*)
    from dt
 -- where dLocation = '' and dcollid = 'MF'
    group by dTypes