×
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.
The following works for me:
SELECT JOB_NAME as JOB_FULL,
JOB_TYPE,
JOB_STATUS,SUBSYSTEM,
AUTHORIZATION_NAME as AUTH_NAME,
SUBSTR(JOB_NAME,1,6) AS JOB_NUMBER, SUBSTR(JOB_NAME,8,POSSTR(SUBSTR(JOB_NAME,8),'/')-1) AS
JOB_USER,
SUBSTR(SUBSTR(JOB_NAME,8),POSSTR(SUBSTR(JOB_NAME,8),'/')+1)
AS JOB_NAME
FROM TABLE(QSYS2.ACTIVE_JOB_INFO(JOB_NAME_FILTER => '*ALL' )) a
Regards,
Richard Schoen
Web:
http://www.richardschoen.net
Email: richard@xxxxxxxxxxxxxxxxx
------------------------------
message: 2
date: Wed, 20 May 2020 15:06:19 +0000
from: Rob Berendt <rob@xxxxxxxxx>
subject: IBM table function to break down fully qualified job name?
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
--
midrange.com
