× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



Something like this:

SELECT aj.JOB_NAME, si.PROGRAM_NAME, si.PROGRAM_LIBRARY_NAME
FROM TABLE(QSYS2.ACTIVE_JOB_INFO(JOB_NAME_FILTER *=>* '*ALL')) aj
JOIN TABLE(QSYS2.STACK_INFO(JOB_NAME *=>* aj.JOB_NAME)) si
on si.PROGRAM_NAME = 'NMFCTLLST';


On 8/6/2023 1:02 PM, John Yeung wrote:
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.

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.