RE: Native Delete vs. SQL

["Lim Hock-Chai" <Lim.Hock-Chai@xxxxxxxxxxxxxxx>]

According to IBM, if the file is already journal, commitment control is
likely to make it perform better.  
http://publib.boulder.ibm.com/iseries/v5r2/ic2924/index.htm?info/rzakj/r
zakjoptimize.htm

As for deleted records - 
Without commitment control, program will have to delete those added
records which cause the file to contains unnecessary deleted record.
This will not happen if commitment control is used.

Commitment Control is a fail-safe control and this is what it designed
to do.



-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Michael Ryan
Sent: Friday, March 23, 2007 11:07 AM
To: RPG programming on the AS400 / iSeries
Subject: Re: Native Delete vs. SQL

Why would commitment control make the process run faster? It would be
slightly slower if anything.

And it would only leave the deleted records in the file if the process
was rolled back, which is what commitment control is designed for.

That being said, I doubt if I would use commitment control for this -
it's not transactional, it's set oriented.

On 3/23/07, Lim Hock-Chai <Lim.Hock-Chai@xxxxxxxxxxxxxxx> wrote:
> I've to disagree and say that Rob's suggestion is likely to be the
best.
> Using CC is likely to make the process to run faster and will not 
> leave those deleted records in the file.
>
> -----Original Message-----
> From: rpg400-l-bounces@xxxxxxxxxxxx
> [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Walden H. Leverich
> Sent: Friday, March 23, 2007 10:51 AM
> To: RPG programming on the AS400 / iSeries
> Subject: RE: Native Delete vs. SQL
>
>
> As for Rob's question about commitment control... CC would be nice 
> here, but I don't think it's really needed. There is a simple, clean 
> way to remove unwanted rows, and I assume you don't need to hold the 
> locks, so it may make more sense to do it w/out CC and just delete the
bad rows.
> -Walden
>
> --
> This is the RPG programming on the AS400 / iSeries (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 AS400 / iSeries (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.