Re: BLOBs
"James H. H. Lampert via MIDRANGE-L" <[email protected]> Tue, 16 Jun 2026 13:53:29 -0700
| Newsgroups | gmane.comp.hardware.ibm.midrange |
|---|---|
| Message-ID | <[email protected]> |
On 6/16/26 12:42 PM, Charles Wilt wrote:
> 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.
Ok, I tried:
> insert into jlib.blobtest1 values(123, get_blob_from_file('/lob1.png')) with chg;
This left a dangling record lock, and the INSERT rolls back when I
disconnect. I added a commit after it, and the insert still rolls back.
I tried "with rr" instead; this gave a warning message, but it did commit.
--
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.