Re: How to merge 2 customers into 1?

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.