Alan,
Do you mean (green screen) STRSQL? If so, AFAIK you can't save/restore
those options. You could either create a small stored procedure with the
parameters you want or use ACS's Run SQL scripts, where you can manage as
many JDBC configuration profiles as you want.
Regards,
Luis
Sent from my Moto G phone. Please excuse my brevity.
On Oct 16, 2017 11:51, "Alan Shore" <ashore@xxxxxxxx> wrote:
Hi everyone
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?
The project that I am working on changes these options so that when I go
into STRSDQL - those changed options are in effect
I don't know what effect this will have on users when I place this project
into production
And google search doesn't seem to come up with anything
Maybe I am asking for the wrong thing
As always - any and all responses MUCH appreciated
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
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit:
https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at
https://archive.midrange.com/midrange-l.
Please contact support@xxxxxxxxxxxx for any subscription related questions.
Help support midrange.com by shopping at amazon.com with our affiliate
link:
http://amzn.to/2dEadiD
midrange.com
