....+....1....+....2....+....3....+....4....+....5....+....6....+....7....+....8....+....9..
MESSAGE_ID  MESSA00001     MESSA00008
 CPF1124    INFORMATIONAL  Job 764754/ROB/ROBS1 started on 10/29/15 at 
08:45:38 in subsystem
 -          REQUEST        /*      */
 -          REQUEST        telnet gdi
 TCP1217    DIAGNOSTIC     Connecting to host gdi.dekko-1 at address 
10.17.6.144 using port 
 TCP2504    COMPLETION     TELNET session ended.  Connection closed.
...
CPD4329    DIAGNOSTIC     Selection for operator X'0042' not valid. Reason 
code 1.
SQL0401    DIAGNOSTIC     Comparison operator LIKE operands not 
compatible.
CPD4318    DIAGNOSTIC     Derived operands not valid for operator CHAR. 
Reason code 6.
SQL0137    DIAGNOSTIC     Result too long.
CPF426A    ESCAPE         User-defined function CONTAINS cannot be 
invoked.
SQ20424    DIAGNOSTIC     Text search support is not available for reason 
3.
-          REQUEST        CPYAUDJRNE ENTTYP(CD) OUTFILE(QGPL/QAUDITCD) 
JRNRCV(*CURCHAIN) FROMTIME(102915 1000) TOTIME(102915 1020)
CPF9801    ESCAPE         Object QAUDITCDCD in library QGPL not found.
CPI2201    INFORMATIONAL  Authority given to user *PUBLIC for object 
QAUDITCDCD in QGPL object type *FILE. 
CPF9862    INFORMATIONAL  Member QAUDITCDCD added to output file 
QAUDITCDCD in library QGPL.
CPC7060    COMPLETION     1 entries converted from journal QAUDJRN in 
QSYS.
...
<snip>
Would that be anything like
SELECT message_id, message_type, message_text, a.*
FROM TABLE(QSYS2.JOBLOG_INFO('*')) A 
http://www-01.ibm.com/support/knowledgecenter/ssw_ibm_i_72/rzajq/rzajqudfjobloginfo.htm?lang=en
</snip>
From:   rob@xxxxxxxxx
To:     Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Date:   10/29/2015 12:53 PM
Subject:        Re: QMHLJOBL API LIST JOB LOG MESSAGES
Sent by:        "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx>
Would that be anything like
SELECT message_id, message_type, message_text, a.*
FROM TABLE(QSYS2.JOBLOG_INFO('*')) A 
http://www-01.ibm.com/support/knowledgecenter/ssw_ibm_i_72/rzajq/rzajqudfjobloginfo.htm?lang=en
Rob Berendt
As an Amazon Associate we earn from qualifying purchases.