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

[Bryan Dietz <bdietz400@xxxxxxxxx>]

Would the new SPLIT UDTf help?
https://www.ibm.com/support/knowledgecenter/ssw_ibm_i_74/rzajq/rzajqudfsplit.htm <https://www.ibm.com/support/knowledgecenter/ssw_ibm_i_74/rzajq/rzajqudfsplit.htm>

Bryan 

> 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