Re: How to merge 2 customers into 1?

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.