Re: BLOBs

On 6/15/26 1:33 PM, Daniel Gross wrote:
> Like this:
> 
> exec sql insert into ... (
>     ...,
>     blobField => get_blob_from_file(:fileName),
>     ...
> );
> 
> (This is new INSERT syntax)
> 
> HTH
> Daniel

Hmm. What is the context on the above?

In both iACS "Run SQL Scripts," if I try to use http_get_blob, according 
to the docs, I get

> Message: [SQL0204] HTTP_GET_BLOB in *LIBL type *N not found.

If I try to use get_blob_from_file, iACS comes back with

> Message: [SQL0443] LOB and XML locators are not allowed with COMMIT(*NONE).

even if I try it on a file in a journaled library, and STRSQL doesn't 
even get that far.

The exact statement that I tried in iACS is:

> insert into jlib.blobtest1 values(123, get_blob_from_file('/lob1.png'));

where "/lob1.png" is a file sitting in the IFS root, jlib is a library 
that is journaled.

--
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.