zOs/SQL/ADBVERS

 select v.versionId,
         char(left(strip(v.owner) || '.' || strip(v.name), 30), 30),
         char(left(strip(l.qualifier) || '.' || strip(l.name), 30), 30),
         l.qCnt,
         v.createdTs
     from s100447.adbcVersion v
       left join (
           select versionId, qualifier, name,
                 count(*) qCnt
             from s100447.adbcVerLines
             group by versionId, qualifier, name
         ) l
         on v.versionId = l.versionId
     where v.owner = 'A540769' and v.name like 'TWK301.TRG%'
     order by v.owner, v.name
     ;
     x
 select v.versionId,
         char(strip(v.owner) || '.' || strip(v.name), 30),
         l.verLinSeq,
         l.operation,
         char(strip(l.qualifier) || '.' || strip(l.name), 30),
         l.rowType,
         createdTs
     from s100447.adbcVersion v
       left join s100447.adbcVerLines l
         on v.versionId = l.versionId
     where owner = 'A540769'
     order by v.versionId, l.verLinSeq