×
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.
"MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx> wrote on 01/04/2018
02:07:01 PM:
OK, next problem. ;-) This works:
I solved it. I removed the QSYS2 qualifier and then got the
following error message.
[SQL0443] JOB_SUBMITTER_FILTER AND JOB_USER_FILTER NOT COMPATIBLE
I took the hint, coded the following, and it worked.
SELECT JOB_STATUS, COUNT(*) as COUNT
FROM TABLE(JOB_INFO(JOB_SUBMITTER_FILTER => '*USER'
, JOB_USER_FILTER => '*ALL')) as JBI
GROUP BY JOB_STATUS
ORDER BY JOB_STATUS;
JOB_STATUS COUNT
ACTIVE 25
OUTQ 799
But I question the results. I don't see how there could be 25
active jobs that were submitted by me nor 799 jobs in out output queue
that were submitted by me. Especially with the following results from teh
WRKSBMJOB command itself.
Work with Submitted Jobs
Submitted from . . . . . . . . : *USER
Type options, press Enter.
2=Change 3=Hold 4=End 5=Work with 6=Release
8=Work with spooled files
Opt Job User Type -----Status-----
(No jobs to display)
Sincerely,
Dave Clark
midrange.com
