Re: Actually using commitment control and QTEMP

[Mike Jones <mike.jones.sysdev@xxxxxxxxx>]

Hi Darren,

Use set option COMMIT = *NC or *NONE, and then for each individual SQL
statement that you wish to participate in a commitment control unit of
work, add the WITH clause with a value other than NC or NONE.

Mike


> date: Thu, 17 Dec 2015 15:00:24 -0500
> from: darren@xxxxxxxxx
> subject: Actually using commitment control and QTEMP
>
> I've actually found a use for turning on commitment control in my SQLRPGLE
> program.  So I did that easy enough with:
>        exec sql set option COMMIT=*CHG;
>
> Do I have to turn off commitment control to work with QTEMP?  If so, how do
> I do that?  I'd like it on for when my program  updates the production
> files its designed to work with.