On Thu, Jan 17, 2013 at 1:46 PM, Gqcy<gmufasa01@xxxxxxxxx> wrote:
Would it be as
"simple" as adding a "strcmtctl" before my call, and a "commit" after it?
Almost, you'd also need to add the COMMIT keyword to the table(s)'s
f-specs in your RPG programs...
Another consideration...how massive is your mass update?
1K rows? 10K rows? 100K rows? 1M?
You can run into performance issues if your commit cycle is to big...
I'll often simply add a counter to the program and do a COMMIT after X
number of rows (either calculate 128K or journal data generated or just
pick a X of 500 or 1000 :)
This mailing list archive is Copyright 1997-2013 by MIDRANGE dot 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 here. If you have questions about this, please contact