Hey IBM DB2 service developers,
Please add the columns:
When using the special value '*' to retrieve information about the
current job you may want to use this function to determine what the
job name, user and number are. For example
SELECT JOB_NUMBER CONCAT '/' CONCAT JOB_USER
CONCAT '/' CONCAT JOB_NAME
FROM TABLE(QSYS2.GET_JOB_INFO('*')) A
So you could then do something like:
select * from qsys2.output_queue_entries
where job_name =
(SELECT JOB_NUMBER CONCAT '/'
CONCAT JOB_USER CONCAT '/'
FROM TABLE(QSYS2.GET_JOB_INFO('*')) A)