Re: Retrieve current jobs subsystem

[dr2@xxxxxxxx]

Kinda surprised that's not in RTVJOBA .....

On 2021-06-28 14:34, Rob Berendt wrote:

> I am using this to retrieve the current jobs subsystem in a stored procedure (written in SPL).
> select v_sbs_name
> into job_subsystem
> from table(qsys2.get_job_info('*'));
> Then I am trying to retrieve that subsystem's status by using this:
> select status
> into Subsystem_status
> from qsys2.subsystem_info
> where sbsd=job_subsystem;
> However there are 7 different libraries on this lpar containing that same *SBSD definition.  Therefore this select blows up.
>
> Get_job_info does not return the subsystem description library.  Sort of like how the DSPJOB command doesn't either.
>
> Rob Berendt
> --
> IBM Certified System Administrator - IBM i 6.1
> Group Dekko
> Dept 1600
> Mail to:  7310 Innovation Blvd, Suite 104
> Ft. Wayne, IN 46818
> Ship to:  7310 Innovation Blvd, Dock 9C
> Ft. Wayne, IN 46818
> http://www.dekko.com