× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



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.



As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.