Re: get_blob_from_file error

[Jason <jason.p1978@xxxxxxxxx>]

This has been resolved by trimming the myfile parameter.

On Wed, Feb 7, 2018 at 10:02 AM, Jason <jason.p1978@xxxxxxxxx> wrote:

> The goal is to insert a blob into a DDL table. If the insert statement
> (see below) is ran via IBM i Access Client Solutions, the record is
> written. Attempting the same insert statement via embedded SQL or as a
> Stored Procedure called via IBM i Access Client Solutions results in an
> error (see below). Has anybody ran into a situation like this? Are there
> any ideas of how to resolve it?
>
> *Example:*
>
>
>
> insert into mylib.mytable
>
>     values(mycharvalue, mydecimalvalue,
>
>            get_blob_from_file(myfile,0),
>
>            0, ' ', ' ', NULL, current_timestamp, myuser);
>
>
>
> *Error:*
>
> Message ID . . . . . . :   CPF503E       Severity . . . . . . . :   30
> Message type . . . . . :   Sender copy
> Date sent  . . . . . . :   01/24/18      Time sent  . . . . . . :
>  09:48:35
>
> Message . . . . :   User-defined function error on member QSQPTABL.
> Cause . . . . . :   An error occurred while invoking user-defined function
>   GET_BLOB_FROM_FILE in library QSYS2. The error occurred while invoking
> the
>   associated external program or service program QDBSSUDF2 in library QSYS,
>   program entry point or external name QSQGTBF, specific name
>   GET_BLOB_FROM_FILE_2. The error occurred on member QSQPTABL file
> QSQPTABL in
>   library QSYS2. The error code is 1. The error codes and their meanings
>   follow:
>     1 -- The external program or service program returned SQLSTATE 42704.
> The
>   text message returned from the program is: *N in *N type *File not
> found..