RE: Capturing the SQL options in RPG

Hi Dave
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

Alan Shore
E-mail : ASHORE@xxxxxxxx
Phone [O] : (631) 200-5019
Phone [C] : (631) 880-8640
'If you're going through hell, keep going.'
Winston Churchill


-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of dlclark@xxxxxxxxxxxxxxxx
Sent: Monday, October 16, 2017 11:59 AM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Subject: Re: Capturing the SQL options in RPG

"MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx> wrote on 10/16/2017
11:50:26 AM:

Before I forget, we are on V7r1

In an RPGSQL program, we can set SQL options - for example exec Sql
Set Option Commit=*CS, CLOSQLCSR=*ENDMOD, DECMPT=*PERIOD; exec Sql Set
Option DATFMT = *ISO;

Is there a way to capture/save these (or any) SQL options - before
they are set?

Those options are set at compile-time (not execution-time) so I am not sure what you're looking for.


Sincerely,

Dave Clark