|
>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.)
As an Amazon Associate we earn from qualifying purchases.
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.
midrange.com
