Re: Limits for SQL functions

[Niels Liisberg <nli@xxxxxxxxxxxxxxxxx>]

The documentation will not give you much Jon:

https://www.ibm.com/docs/en/i/7.5?topic=functions-get-blob-from-file

But if you use RPG  you need a locator - long varchars are not supported
(AFAIK)

On Mon, Nov 11, 2024 at 9:14 PM Jon Paris <jon.paris@xxxxxxxxxxxxxx> wrote:

> Can anyone tell me where i can find documentation on the limits for the
> SQL functions such as GET_BLOB_FROM_FILE.
>
> I am getting a "not usable" error when trying to use a host variable > 32K
> - but the only docs I can find relate just to BLOB and they sure don't have
> such a low limit.
>
> Is there some special magic required for large objects?
>
>
> Jon Paris
> Jon.Paris@xxxxxxxxxxxxxx
>
>
>
> --
> 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.