Re: SQLRPGLE commit=^none and commit=*chg

Instead of CREATE TABLE QTEMP.X ... you should use DECLARE GLOBAL TEMPORARY TABLE X.
If a temporary table is generated with DECLARE GLOBAL TEMPORARY TABLE, it is possible to INSERT, UPDATE, DELETE rows without specifying WITH NC.
... and DECLARE GLOBAL TEMPORARY TABLE, INSERT, UPDATE and DELETE are executed under commitment control, i.e. ROLLBACK will reset all modification within this table since the last COMMIT.
...

Mit freundlichen Grüßen / Best regards

Birgitta Hauser

"Shoot for the moon, even if you miss, you'll land among the stars." (Les Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them? Not training them and keeping them!"
„Train people well enough so they can leave, treat them well enough so they don't want to.“ (Richard Branson)