× 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.



You are right, of course. I'm afraid I did not check my answer thoroughly,
my apologies (my STRSQL session had the COMMIT set to *NONE).

Rob, my apologies. Your post is ok.

Regards,

Luis Rodriguez
IBM Certified Systems Expert — eServer i5 iSeries


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

Note that SQL delete will work two different ways depending upon the
use of commitment control or not.

From the v5r4 manual:
DELETE Performance: An SQL DELETE statement that does not contain a
WHERE clause will delete all rows of a table. In this case, the rows
may be deleted using either a clear operation (if not running under
commitment control) or a change file operation (if running under
commitment control). If running under commitment control, the deletes
can still be committed or rolled back. This implementation will be
much faster than individually deleting each row, but individual
journal entries for each row will not be recorded in the journal.

Charles

On Thu, May 6, 2010 at 10:25 AM, Luis Rodriguez <luisro58@xxxxxxxxx>
wrote:
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.


--
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 ...

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.