Retrieve Job Attributes (RTVJOBA) UDTF

Index

Schema IQUERY

RTVJOBA( job_name => '*' )

The Retrieve Job Attributes (RTVJOBA) User Defined Table Function returns one row containing the attributes for the specified job.

Parameters

JOB_NAME

The fully qualified job name of the job whose attributes should be returned. The format is 666666/NNNNNNNNNN/UUUUUUUUUU wherer 666666 is the job number, NNNNNNNNNN is the job name and UUUUUUUUUU is the User Profile of the job. If unspecified, then the attributes for the current job (the one running the UDTF) are returned.

Examples

select outq_name, outq_lib, date_job_active from table( iQuery.rtvjoba('862386/QLWISVR/ADMIN1')) adminJobInfo;

Column Data Type Description
JOB
VARCHAR(28)
The name of the job whose attributes are returned.
JOB_STATUS
VARCHAR(10)
Job Active (*ACTIVE, *JOBQ, *OUTQ)
JOB_ACTIVE VARCHAR(4) Active Job Status .
JOB_TYPE
CHAR(1) Job Type (I=Interactive, B=Batch,
JOB_SUBTYPE
CHAR(1)
The subtype of the job.
JOB_NAME VARCHAR(10) The job name.
jOB_USER VARCHAR(10)
The User Profile under which the job started.
JOB_NBR
VARCHAR(6) The job number.
JOB_DATE
date
The Date for the Job (the "job date")
DATE_JOB_ENTERED_SYSTEM
timestamp
A timestamp of when the job was submitted.
DATE_JOB_ACTIVE
timestamp
A timestamp of when the job started running.
JOB_INTID
BINARY(16)
A unique 16-byte value that represents the job identity to the system.
JOBQ_NAME
VARCHAR(10)
The name of the JOBQ to which the job was submitted when it entered the system.
JOBQ_LIB
VARCHAR(10)
The library for the JOBQ.
JOBQ_STATUS
VARCHAR(10)
If the job is currently on a JOBQ, this is the status of that job on the JOBQ.
JOBQ_PTY
VARCHAR(2)
If the job is currently on a JOBQ, this is the Priority of that job on the JOBQ.
OUTQ_NAME
VARCHAR(10)
The Output Queue assigned t the job.
OUTQ_LIB
VARCHAR(10)
The Output Queue library name.
OUTQ_PTY
VARCHAR(2)
The Priority of SPOOLED file placed on the Output Queue.
PRTDEV
VARCHAR(10)
The Printer device assigned to the job.
JOBD_NAME
VARCHAR(10) The Job Description under which the job is running.
JOBD_LIB
VARCHAR(10) The Job Description Library.
JOBLOG_OUTPUT
VARCHAR(10) The status of the joblog for the job.
JOBLOG_PENDING
CHAR(4) Is the joblog in a pending state: *YES, *NO
MODE_NAME
VARCHAR(8)
APPC Mode name.
INQMSGRPY
VARCHAR(10)
Inquiry Message Reply Handling
LOGCLPGM
VARCHAR(10) Log CL Program
BRKMSGHDL
VARCHAR(10) Break Message Handling
STSMSGHDL
VARCHAR(10) Status Message Handling
DECFMT
CHAR(1)
Decimal Format. If blank then period for decimal point, comma for thousands notation. J or I indicate a comma is used for decimal point and a period is used for thousands notation.
DATESEP
CHAR(1)
Date Separator Character
DATEFMT
CHAR(4)
A 3-character date format (such as MDY, YMD, DMY, etc) following a leading asterisk. That is *MDY, *YMD, *DMY or *JUL
TIMESEP
CHAR(1)
The separator symbol for TIME values.
TIME_ZONE
VARCHAR(10) The Time Zone abbreviation used for the job.
DAYOFWEEK
VARCHAR(4)
The Day of the week, *SUN *MON *TUE *WED *THR *FRI *SAT
LANGUAGE_ID
VARCHAR(3)
The Language ID for the job, e.g., ENU
COUNTRY_ID
VARCHAR(2)
The Country code for the Job, e.g., US
CHAR_ID_CTRL
VARCHAR(10)
The character identifier control for the job. *DEVD * JOBCCSID
CCSID
int
The CCSID for the Job.
DFTCCSID
int
The Default CCSID for the job if the CCSID for the Job is 65535.
JOB_GRPPRF
VARCHAR(10) The Group User Profile associated with the user running the job.
JOB_CURUSRPRF
VARCHAR(10) The Current User Profile under which the job is running.
SBMJOB_NAME
VARCHAR(10) The name of the job that submitted this job.
SBMJOB_USER
VARCHAR(10) The User profile under which the job that submitted this job was running.
SBmJOB_NBR
VARCHAR(6) The job number of the job that submitted this job.
SBMJOB_MSGQ
VARCHAR(10) The Message queue of the job that submitted this job.
SBMJOB_MSGQ_LIB
VARCHAR(10) The Message queue library for the message queue of the submitter's job.
JOB_SUBSYSTEM
VARCHAR(10) The subsystem in which the job is running.
JOB_SUBSYSTEM_LIBRARY
VARCHAR(10) The subsystem library
END_SEV
int
Maximum error severity before the job ends.
LOG_LEVEL
int
Message Logging Level (1 to 4)
LOG_SEV
int
Message Logging Severity (0 to 99)
LOG_MSGTEXTLVL
VARCHAR(10) Message Text Logging Level: *MSG *SECLVL *NOLIST
JOB_SWITCHES
CHAR(8) UPSI "Switch" Setting.
MULTITHREAD
VARCHAR(4)
The job allows multi-threads.  *YES, *NO
END_STATUS
CHAR(1)
'0'=Job is running. '1'=Job is in cancel mode.
EXIT_KEY
CHAR(1)
The exit key (F3) was used to end the application.
CANCEL_KEY
CHAR(1) The cancel key (F12) was used to end the application.
DEVNAME
VARCHAR(10)

CLIENT_IP
VARCHAR(15)
The IPv4 address for the Client that is attached to this job.
SYSLIBL_COUNT
int
The number of libraries on the System Portion of the Job's library list.
PRODLIB_COUNT
int
The number of libraries as the Production Library. This value is 0, 1, or 2.
CURLIB_COUNT
int
The number of current libraries. This number is 0 or 1.
USRLIBL_COUNT
int
The number of libraries on the User Portion of the Job's library list.
SYSLIBL
VARCHAR(165)
The library names on the job's system library list. Each library name occupies 10 characters regardless of the length of the library name. There is also 1 pad character after each library name to separate it from the next.
PRODLIB
VARCHAR(22)
The names of any libraries on the Product Library portion of the library list. Up to 2 library names may appear; each using 10 positions with an additional trailing blank.
CURLIB
VARCHAR(10)
The current library (if any). The special value *CRTDFT may appear here. If so, it implies that QGPL is used as the current library.
USRLIBL
VARCHAR(2750)
The library names on the user portion of the job's library list appear here. Each occupies 10 characters and is followed by a trailing blank.
RTGDATA
VARCHAR(80)
The routing data used to route the job when the job started (from the CLASS object).