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 <
[email protected]> 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: [email protected]
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/midrange-l
> or email: [email protected]
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/midrange-l.
>
> Please contact [email protected] for any subscription related
> questions.
>
>
-- 
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: [email protected]
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact [email protected] for any subscription related questions.