RE: IBM API QGYOLJOB

SELECT * FROM table(qsys2.job_info()) x WHERE job_status in
('JOBQ','ACTIVE')
and job_name like ('%KEVIN%')

Kevin Bucknum
Senior Programmer Analyst
MEDDATA/MEDTRON
Tel: 985-893-2550

-----Original Message-----

From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf
Of dlclark@xxxxxxxxxxxxxxxx
Sent: Thursday, January 4, 2018 10:56 AM
To: Midrange-L
Subject: IBM API QGYOLJOB


I'm looking at IBM API QGYOLJOB. I need to create a list of

jobs in either

status *JOBQ or *ACTIVE that is filtered by a submitter's qualified

job name.

I can see how to create a list of jobs with those statuses and also

return the

associated submitter's qualified job name for each entry. But I don't

see how

to filter such a list by that submitter.
We regularly have in excess of 20,000 active jobs on the system. I

don't want

a list of all jobs on the system and then have to search through that

list to

find the matching submitter. Am I missing something? Thanks for any

hints

or suggestions.

Sincerely,

Dave Clark
--
int.ext: 91078
direct: (937) 531-6378
home: (937) 751-3300

Winsupply Group Services
3110 Kettering Boulevard
Dayton, Ohio 45439 USA
(937) 294-5331



**********************************************************
***********************************
This email message and any attachments is for use only by the named
addressee(s) and may contain confidential, privileged and/or

proprietary

information. If you have received this message in error, please

immediately

notify the sender and delete and destroy the message and all copies.

All

unauthorized direct or indirect use or disclosure of this message is

strictly

prohibited. No right to confidentiality or privilege is waived or lost

by any

error in transmission.
**********************************************************
***********************************
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing

list

To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take
a moment to review the archives at
https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: http://amzn.to/2dEadiD