Re: BRMS IFS save start and end times - IFS locks

First of all I think your email had some typos or grammatical errors. Save
while active on IFS is a sick joke.

Something like this then?
select a.job_name, b.*
from table(qsys2.job_info(
JOB_USER_FILTER => 'QUICK')) a,
lateral (select * from table(qsys2.joblog_info(a.job_name)) x) b
where (a.job_name like '%MONDAYEDD%'
or a.job_name like '%TUE_FRIEDD%')
and b.message_id in('CPF3837', 'BRM14A1', 'BRM1413');



Rob Berendt