How to get the output of journal data like a physical file data to use in STRSQL?

425 pts.
Tags:
AS/400
AS/400 journaling
AS400 physical file
DSPJRN
IBM iSeries
STRSQL
HI All, Normally DSPJRN is used to display the Journal, but however its not in a understandable way. Can any one suggest how to get the output of journal data like a pfhysical file data to use in STRSQL.

Software/Hardware used:
Iseries

Answer Wiki

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

Go to the AS400 Freeware website

http://www.tools400.de/English/Freeware/Utilities/utilities.html

Download EXPJRNE

Discuss This Question: 1  Reply

 
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
    First, are you interested in a database journal, a system journal such as QAUDJRN or QACGJRN, a journal for IFS streamfiles or some other journal function? Database journals are fairly common for what you asked. Use DSPJRN to generate an outfile of entries. The outfile will have a bunch of fields at the beginning of each record that identify the journal entry and a big field at the end that holds the ESD (the 'entry-specific data'). The ESD is simply a record image from the file that was journaled. Because of that, you can create a new file with a record format that joins all of the outfile fields except the ESD field with all of the database file fields. A fairly simple SQL statement can create that new file. Once the new file exists, use CPYF with FMTOPT(*NOCHK) to do an image-copy from your journal outfile into your newly created file. Everything within the ESD will overlay the field definitions that you supplied. You can then query that new file to see the data all neatly defined. Tom
    125,585 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