Home > IT Answers > AS/400 > AS400 DB2
Esjef44
5 pts.
 AS400 DB2
AS/400, AS/400 database, DB2, iSeries, Journal Receivers
How do I access the data in a journal receiver?

Software/Hardware used:
iSeries
ASKED: February 8, 2011  9:17 PM
UPDATED: February 9, 2011  10:06 PM
RELATED QUESTIONS
Answer Wiki:
You use the DSPJRN command. Last week I answered a similiar question and suggest that you download the FREE command EXPJRNE. Here is the link http://www.tools400.de/English/Freeware/Utilities/utilities.html The reason this is nice with the DSPJRN you get individual fields for all the "extra" stuff, when the entry was done, who did it, etc.. But he data for for the record from your file is just one character string. The EXPJRNE also will split that character string into individual fields.
Last Wiki Answer Submitted:  February 8, 2011  10:00 pm  by  CharlieBrowne   32,945 pts.
All Answer Wiki Contributors:  CharlieBrowne   32,945 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

You can use DSPJRN to view the entries or to output them to a database file. You can use the RCVJRNE command to receive entries (or blocks of entries) into a program in near real-time as entries are added to the journal receiver. You can use the RTVJRNE command to retrieve specific entries (or blocks) into a CL program.

The Retrieve Journal Entries (QjoRetrieveJournalEntries) API can also be used to retrieve entries into programs.

Tom

TomLiotta
 108,360 pts.
 

It may help to look through this IBM Red book.

HMSSL2K
 3,175 pts.