Re: How to merge 2 customers into 1?

[Luis Rodriguez <luisro58@xxxxxxxxx>]

Charles is right. IIRC, since V5R3 a DELETE without a where clause, when the
table is not being used by any other process (ie, the DELETE can do a
exclusive lock to the table) , it is the same as a CLRPFM which, AFAIK, is
not recoverable using journals...

It seems that Rob's post would need some minor changes. Nevertheless, I
still think is a nice intro.

Rob: Would you mind if I use your post as a base for a small article for the
midrange wiki?

David: You can find a list of the Journal Codes V5R4 here:

http://publib.boulder.ibm.com/infocenter/iseries/v5r4/topic/rzaki/rzakijournalfinderall.htm





Regards,

Luis Rodriguez
IBM Certified Systems Expert — eServer i5 iSeries


On Thu, May 6, 2010 at 9:26 AM, Charles Wilt <charles.wilt@xxxxxxxxx> wrote:

> Nope,
> 16 -F OP - File Open
> 17 - F  CL - File Close
>
> Now
> 15 - F CR - File Clear
>
> is another story. :)
>
> That's from either CLRPFM or an SQL DELETE without a where clause.
>
> Charles
>
>
>
> On Thu, May 6, 2010 at 8:37 AM, David FOXWELL <David.FOXWELL@xxxxxxxxx>
> wrote:
> > > -----Message d'origine-----
> > > [mailto:rpg400-l-bounces@xxxxxxxxxxxx] De la part de Luis Rodriguez
> >
> > >  A while back Rob Berendt wrote this wonderful intro to
> > > Journals:
> > > http://archive.midrange.com/midrange-l/200908/msg00887.html
> > >
> > > Check it. I think you will find it worthwhile...
> >
> > Hey, I just got into journalling! See, if you don't post, you don't
> learn.
> > Trouble is, I just ran the sql bit from hell, there are no records left
> but nothing in the journal except :
> > Opt   Séquence   Code   Type   Objet   Bibliothèque   Travail   Heure
> >             15   F     CR   ARHDMN      FOXWELL     DFX3        14:26:09
> >             16   F     OP   ARHDMN      FOXWELL     DFX3        14:28:02
> >             17   F     CL   ARHDMN      FOXWELL     DFX3        14:28:03
> >
> > I think the 16 and 14 pertain to my sql delete.
> > --
> > This is the RPG programming on the IBM i / System i (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.
> --
> This is the RPG programming on the IBM i / System i (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.