zOs/SQL/CATPKGVE

select distinct
       --  char(strip(collid), 8)   collid,
       --  char(strip(pkg), 8)     pkg,
           char(strip(version), 26) version,
       --  contoken,  -- vovie,
       --  char(strip(owner), 8)    owner,
           bindTime
from
(
select     collid, name pkg, version, hex(conToken) conToken,
           valid || operative || validate || isolation || explain vovie,
           owner, bindTime
    from sysibm.sysPackage
union all select
      collid, progname pkg, version, '-- plan tb --' conToken,
           '     ' vovie,
           '     ' owner, bind_Time bindTime
    from cmnbatch.plan_table
    group by collid, progname, version, bind_time
) j
where pkg = 'YNI601G'
-- order by collid, pkg, version, bindTime, conToken
order by 1, 2