RE: BLOBs

Well, you can do it via STRCMTCTL CMTSCOPE(*JOB) to get beyond the activation group. But it is probably more standard in Run SQL Scripts (RSS) to set the "Isolation Level" on the System page of the JDBC Configuration. You would need to read and understand about Commitment Control from the IBM Knowledge Center. It's been quite a while since I did anything using commitment control from RSS so my memory could fail me. That said, I believe you have finer control using STRCMTCTL. Under the covers, it's all the same. Perhaps Birgitta or someone else more knowledgeable can weigh in here. (Sorry to drop your name uninvited, Birgitta--I just always appreciate your input.)

Thanks,
Michael Quigley
Computer Services
www.TheWay.org

-----Original Message-----
message: 4
date: Tue, 16 Jun 2026 14:06:53 -0500
from: Bryan Dietz <[email protected]>
subject: Re: BLOBs

set up a new JDBC setting. <connection><connected  > <edit,change,apply> lots of options.

Bryan

> On Jun 16, 2026, at 12:41 PM, James H. H. Lampert via MIDRANGE-L <[email protected]> wrote:
> 
> On 6/16/26 10:28 AM, Michael Quigley wrote:
>> CL: STRCMTCTL .... ; would be your friend.
> 
> I saw that, but it appears to have either job or activation group scope; how would one use it from iACS "Run SQL Scripts"?
> 
> --
> JHHL
-- 
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: [email protected]
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request-+hD5IHI5Xscn3HwCXmMcX9BPR1lH4CV8@public.gmane.org
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support-FMtJrHiV//lnDLsaKlm4mFaTQe2KTcn/@public.gmane.org for any subscription related questions.