zOs/SQL/BINDHISG

select genTst, result, rz, dbSys, pgm, line
       , g.genId, CMPKG, cOM, cmJob, appl, instALL, result, resTst
    from oa1p.tQZ043BindGen g
      left join oa1p.tQZ044BindLine l
        on g.genId = l.genId and seq = 1
      where pgm <> ''
    order by genTst desc