Re: Housekeeping

[Suresh K <vijisur@xxxxxxxxxxxxxxx>]

Hi,

Thanx for the help.

During trial with SQLRPG, ommitted COMMIT statemnt under the assumption that
AUTOCOMMIT is active. After SIGNOF system started rolling back and it took same
time as COMMIT. Moreover there were plenty of Jouranl receivers which could not
be touched.

Viji Suresh

"Walden H. Leverich" wrote:

> >From: Suresh K [mailto:vijisur@emirates.net.ae]
> >RPG or SQLRPG is better for this?
>
> What are the keys to the data. I'd guess that a 'insert into archive select
> * from transaction where xxx' followed by a 'delete from transaction where
> xxx' would be the fastest. Depending on the available keys you should be
> able to commit on a reasonably small chunk of data, although if you really
> wanted to you could do all 8Mil in one commitment block -- just hope you
> never have to rollback.
>
> This could possibly be done with a CL that did a runsqlstm from a source
> member if you wanted to.
>
> -Walden
>
> ------------
> Walden H Leverich III
> President
> Tech Software
> (516) 627-3800 x11
> (208) 692-3308 eFax
> WaldenL@TechSoftInc.com
> http://www.TechSoftInc.com
>
> Quiquid latine dictum sit altum viditur.
> (Whatever is said in Latin seems profound.)
>
> _______________________________________________
> This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
> To post a message email: RPG400-L@midrange.com
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/cgi-bin/listinfo/rpg400-l
> or email: RPG400-L-request@midrange.com
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.