Re: IBM table function to break down fully qualified job name?

On May 20, 2020, at 11:06 AM, Rob Berendt <rob@xxxxxxxxx> wrote:

Is there an IBM supplied table function to break down the fully qualified job name, even if the job is completed? For example

Select
Job_number,
Job_user,
Job_name
From table(breakdown_qualified_job_name('*')) A
;

Or
Select
Job_number,
Job_user,
Job_name
From table(breakdown_qualified_job_name('123456/jobuser/jobname')) A
;

I could write one but would rather not reinvent the wheel.

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

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related questions.

Help support midrange.com by shopping at amazon.com with our affiliate link: https://amazon.midrange.com