What are the ways to display journal entries in as400?
Sorry, you do not have permission to ask a question, You must login to ask a question.
Sorry, you do not have permission to ask a question.
What are the ways to display journal entries in as400?
You can view journal entries using the Display Journal (
DSPJRN
) command. The journal entries can be displayed, printed, and written in the outfile.You can view journal entries in SQL using the table function
DISPLAY_JOURNAL
in the QSYS2 library. This table function returns information about journal entries and is similar to what the Display Journal (DSPJRN) command returns.You can also use the Retrieve Journal Entries (
QjoRetrieveJournalEntries
) API to view information on journal entries.You can use this SQL query
SELECT * FROM TABLE(QSYS2.DISPLAY_JOURNAL( 'TESTLIB', 'Journal_Name')) AS JT