RE: Retrieve current jobs subsystem

Thank you, that will work like a champ.

I can pass the results from
SELECT subsystem, subsystem_library_name
FROM TABLE(QSYS2.ACTIVE_JOB_INFO(
JOB_NAME_FILTER => '*')) X
;
To
select status
from qsys2.subsystem_info
where subsystem_description='QUSRWRK'
and subsystem_description_library='QSYS'
;

By using this:
select status
from qsys2.subsystem_info
where subsystem_description concat subsystem_description_library in(
SELECT subsystem concat subsystem_library_name
FROM TABLE(QSYS2.ACTIVE_JOB_INFO(
JOB_NAME_FILTER => '*')) X)
;
Although if there is a cleaner way to have multiple columns on an IN clause other than concatenation I'm all ears.


Rob Berendt