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