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 <bdietz400@xxxxxxxxx>
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 <midrange-l@xxxxxxxxxxxxxxxxxx> 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