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 :)
Charles
