Re: Extracting data from a journal

There are a few ways to do this.  First of all, there is the DSPJRN
command.  Using this command, you can create an output file of journal
entries, including before and after images.  The data for the before and
after images are contained in a field, over which you can apply a data
structure, and get the fields.  Look in the iSeries info center for info
relating to this command.

Another, faster way is to use the QJoRetrieveJournalEntries API.  This API
retrieves journal entries into a user space, and you can use pointers to
'tow' data structures through the user space, and retrieve the entries.  The
best examples on this method are found here:
http://www.iseriesnetwork.com/noderesources/code/clubtechcode/RetrieveJournalEntries.zip.


On 12/15/05, michaelsoucy@xxxxxxxxxxx <michaelsoucy@xxxxxxxxxxx> wrote:
>
> I've turn journaling on for a file on our iSeries.  Does anyone know if
> there is a way to access the "before" or "after" images that are in the
> journals in a RPG program?  It would be very helpful if this could be
> done?  If someone has done this can you please share some examples of how
> this is done?
>
> Thanks,
> Michael Soucy
> michaelsoucy@xxxxxxxxxxx
>
>
>
> --
> This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.
>
>


--
"Enter any 11-digit prime number to continue..."
"In Hebrew SQL, how do you use right() and left()?..." - Random Thought
"If all you have is a hammer, all your problems begin to look like nails"