Re: Strickly for old timers

[John Yeung <gallium.arsenide@xxxxxxxxx>]

On Sun, Aug 6, 2023 at 4:00 AM Gad Miron <gadmiron@xxxxxxxxx> wrote:
> I thought I'd combine the two to finally get my IF_ACTIVE.
> So here is an SQL that I think should accomplish it but does not:
>
> SELECT PROGRAM_NAME, PROGRAM_LIBRARY_NAME
> FROM TABLE(QSYS2.STACK_INFO((SELECT distinct JOB_NAME
> FROM TABLE(QSYS2.ACTIVE_JOB_INFO(JOB_NAME_FILTER => '*ALL'))) ,'ALL')) A
> where PROGRAM_NAME = 'NMFCTLLST'
>
> I get a "Result of SELECT more than one row"
>
> Any ideas, anyone?

It looks like you want to check the stack of every active job. But the
STACK_INFO table function only returns the rows for one job. Where it
expects the job name, you can't just pass it a set of job names.

You have to retrieve the set of job names, and then for *each* of
those, call STACK_INFO.

John Y.