dennisnel

-- DISPLAY_JOURNAL
-- https://www.ibm.com/docs/en/i/7.5?topic=services-display-journal-table-function 

SELECT * FROM TABLE (
                 QSYS2.DISPLAY_JOURNAL( 'JRNLCLOBJ', 'SFL',
--                  JOURNAL_CODES => 'D,F,R',
                 STARTING_RECEIVER_NAME => '*CURCHAIN', 
                 OBJECT_OBJTYPE=>'*FILE',
                 OBJECT_LIBRARY=>'PLTQSUAT', 
                 OBJECT_NAME=>'APXCLTCSV',

dennisnel

#  ---------------------------------------------------------------------------
#
#  Description:  This file holds all my BASH configurations and aliases
#
#  Sections:
#  1.   Environment Configuration
#  2.   Make Terminal Better (remapping defaults and adding functionality)
#  3.   File and Folder Management
#  4.   Searching
#  5.   Process Management

dennisnel

--
-- https://www.ibm.com/support/knowledgecenter/ssw_ibm_i_73/rzajq/rzajqudfjobloginfo.htm
--

SELECT MESSAGE_ID,MESSAGE_TEXT,MESSAGE_SECOND_LEVEL_TEXT
  --FROM TABLE(QSYS2.JOBLOG_INFO('*'))
  FROM TABLE(QSYS2.JOBLOG_INFO('676430/AZOWNER/SCD_COB'))
 ORDER BY ORDINAL_POSITION DESC
;