Re: BLOBs

all you need to do is add

with chg

to the end of your SQL statement, that will automatically start
commitment control if not already started.

HTH,
Charles

On Tue, Jun 16, 2026 at 9:29 AM James H. H. Lampert via MIDRANGE-L <
midrange-l@xxxxxxxxxxxxxxxxxx> wrote:

On 6/15/26 9:22 PM, Birgitta Hauser wrote:

It is "GET_BLOB_FROM_FILE" ... and the function has to be run under

commitment control

Yes. That much I was able to determine. That's why I set up a journaled
library for my BLOB test file. It's been a very long time since I even
looked at commitment control, and I was under the impression that having
journaling enabled on the file was all I needed.

Assuming I even *can* enable commitment control in iACS "Run SQL
Scripts," what else do I need to do?

--
JHHL
(once again getting the all-too-familiar urge to retire to the
back-country and live in a wigwam)
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.