Okay, I never knew there was an alternative to the out queue. Sort of like
not knowing there was Midrange until Jon pointed it out to me. And I'm not
one wedded to doing something the same way all of the time.
Thanks for passing all if this along. Really appreciated.
Jerry C. Adams
To lose one parent may be regarded as a misfortune; to lose both looks like
carelessness. -Oscar Wilde
IBM i Programmer/Analyst
--
NMM&D
615-832-2730
-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Rob
Berendt
Sent: Friday, October 19, 2018 3:04 PM
To: Midrange Systems Technical Discussion
Subject: Re: JobLog Creation
So you would start with
SELECT JOB_NAME FROM TABLE(QSYS2.JOB_INFO(JOB_TYPE_FILTER => '*ALL')) X
WHERE JOB_STATUS not in ('*ACTIVE', '*JOBQ');
And pass JOB_NAME into
SELECT * FROM TABLE(QSYS2.JOBLOG_INFO(:job_name)) A
Rob Berendt
--
IBM Certified System Administrator - IBM i 6.1 Group Dekko Dept 1600 Mail
to: 2505 Dekko Drive
Garrett, IN 46738
Ship to: Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com
From: "Rob Berendt" <rob@xxxxxxxxx>
To: "Midrange Systems Technical Discussion" <midrange-l@xxxxxxxxxxxx>
Date: 10/19/2018 03:56 PM
Subject: Re: JobLog Creation
Sent by: "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx>
I shorthanded that just a little bit too much.
QSYS2.JOBLOG_INFO is a "UDTF" not a "VIEW". Therefore you have to do it a
little differently.
SELECT * FROM TABLE(QSYS2.JOBLOG_INFO('291425/ROB/ROBHQ1')) A
https://www.ibm.com/developerworks/community/wikis/home?lang=en#!/wiki/IBM%2
0i%20Technology%20Updates/page/QSYS2.JOBLOG_INFO()%20UDTF
Rob Berendt
midrange.com
