Re: Help with journals

[Thomas Garvey <tgarvey@xxxxxxxxxx>]

Too bad you didn't have Stitch-in-Time to use.



Best Regards,

Thomas Garvey


On 1/12/2015 9:16 PM, Darryl Freinkel wrote:
> I think I have the issue resolved. It will take a few days to confirm.
>
> DSPJRN will not provide information about a deleted member when doing a *ALL. You need to display the member data only. That makes the restoring of a member a 2 step operation.
>
> I am going to have to list all MA records to get the list of members. Then restore the members one by one.
>
> Sent from my iPad
>
> > On Jan 12, 2015, at 5:10 PM, Monnier, Gary <Gary.Monnier@xxxxxxxxx> wrote:
> >
> > Try the following:
> >
> >     DSPJRN JRN(yourjournalname) FILE((yourfilename *ALL)) RCVRNG(*CURCHAIN) FROMTIME(startdate&time) TOTIME(enddate&time) JRNCDE((R)) OUTFILFMT(*TYPE5)
> >     OUTFILE(youroutfilename)
> >
> > The journal code R will provide all transactions found in the journal receivers, including before and after images.
> > If you leave journal code at *ALL you will also get the entries creating and removing members.
> >
> > Rebuild the file by reading the JRNCODE R records, placing the entry specific data into a data structure mirroring your table format and write the desire entries to a temporary table.  If they look correct, copy them to where you need them.  Member name will be in the fixed length portion of the journal entries.
> >
> > HTH
> >
> > -----Original Message-----
> > From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of DFreinkel
> > Sent: Monday, January 12, 2015 1:48 PM
> > To: Midrange
> > Subject: Help with journals
> >
> > I need to read the journal files to display who dunnit.
> >
> > Our system uses members as work files and they are removed after the batch is updated.
> >
> > I need to be able to display those batches from the journal but because the members were removed they are not directly accessible from the journals.
> >
> > There is a work around to this but I do not remember how.
> >
> > Can anyone assist?
> >
> > Tia,
> >
> > Darryl
> >
> >
> >
> > Sent from my iPad
> > --
> > This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
> > visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> > or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/midrange-l.
> >
> > --
> > This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> > To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> > To subscribe, unsubscribe, or change list options,
> > visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> > or email: MIDRANGE-L-request@xxxxxxxxxxxx
> > Before posting, please take a moment to review the archives
> > at http://archive.midrange.com/midrange-l.