RE: Capturing the SQL options in RPG

"MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx> wrote on 10/16/2017
12:02:12 PM:

I thought these were set at run time
Hence my question on how to capture them BEFORE they were set
exec Sql Set Option Commit=*CS
as well as
exec Sql Set Option Commit=*NONE

They take affect at run time but they are set (and can't be
changed) at compile time. These options take affect on a
program-by-program basis and do not affect the options for other programs
(such as STRSQL). Having said that, there are certainly some
considerations on an activation group basis. For example, you don't want
to be mixing the level of commitment control used within a single
activation group. I have seen SQL complain about that.


Sincerely,

Dave Clark