AS400 DB2

5 pts.
Tags:
AS/400
AS/400 database
IBM DB2
IBM iSeries
Journal Receivers
How do I access the data in a journal receiver?

Software/Hardware used:
iSeries

Answer Wiki

Thanks. We'll let you know when a new response is added.

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.

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • TomLiotta
    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
    125,585 pointsBadges:
    report
  • HMSSL2K
    It may help to look through this IBM Red book.
    3,175 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following