zOs/SQL/CATPKCO

with u as
(
  select 'pk' || copyid t, p.* from sysibm.sysPackage p
  union all select 'co' || copyid t, c.* from sysibm.sysPackCopy c
)
select *
   from u
   where location = '' and collid = 'DSNREXX_500'
;
select *
    from sysibm.syspksystem