RE: Query mult joblogs for string

[Rob Berendt <rob@xxxxxxxxx>]

Something like this:
  select a.job_name, b.message_id, b.message_text, b.*
   from table(qsys2.job_info(
   JOB_USER_FILTER => 'QUSER')) a,
   lateral (select * from table(qsys2.joblog_info(a.job_name)) x) b
   where a.job_name like('%QZLSFILET%')
      and b.message_id in('CPIAD12');

Rob Berendt