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

[Booth Martin <booth@xxxxxxxxxxxx>]

This is a whole new concept for me.  Looks like this is a path well 
worth exploring.  Thank you.

On 12/15/2019 8:39 AM, Birgitta Hauser wrote:
> 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)