Re: Library List of Data Queue Jobs

So basically you're looking for the following occurrence in a joblog?
select message_id, MESSAGE_TEXT
from table(qsys2.joblog_info('504922/ROB/ROBHQ1')) a
where message_id in('CPC2196', 'CPC2197', 'CPC2198')

Test this using the following in Run SQL Scripts:

*CL:* *ADDLIBLE* ERPLXF;
*CL:* *RMVLIBLE* ERPLXF;
*CL:* *CHGCURLIB* ERPLXF;
*CL:* *CHGCURLIB* QGPL;

select message_id, MESSAGE_TEXT
from table(qsys2.joblog_info('504922/ROB/ROBHQ1')) a
where message_id in('CPC2196', 'CPC2197', 'CPC2198');

select *
from qsys2.library_list_info;