Re: Problem retrieving BLOB using SQLRPGLE

["Art Tostaine, Jr." <atostaine@xxxxxxxxx>]

Thanks Mark.  It says the length of the filename is invalid.  I think I
know what's wrong.

Art

On Sun, Jun 23, 2019 at 12:22 PM Mark Waterbury <
mark.s.waterbury@xxxxxxxxxxxxx> wrote:

>  Find and examine the corresponding SQL0452 error message in the job log.
> It contains important details such as the "reason code"  -- with an
> explanation of each reason code, and suggests corrective actions for each
> possible reason code that could be returned.
>
>
>     On Sunday, June 23, 2019, 11:58:01 AM EDT, Art Tostaine, Jr. <
> atostaine@xxxxxxxxx> wrote:
>
>  I am doing a SQL Select on a row that I know is there.  I am getting
> SQLSTT
> 428A1
>
> 428A1 Unable to access a file referenced by a file reference variable.
>
> Most rows retrieve fine.
>
> This is my code that Birgitta orignally posted awhile ago
>
> D Blob            s                  SQLTYPE(BLOB_FILE)
>
> BLOB_NAME = '/tmp/RD_' +
> %trim(%editc(rid:'X')) + '_' + %trim(%editc(dwlineNo:'X')) + '.jpg';
>
> blob_nl = %len(%trim(blob_name));
> blob_fo = SQFOVR;
>
> EXEC SQL Fetch Next from C1 into :rid, :DwLineNo, :Blob;
>
> Thanks
> --
> Art Tostaine
> --
> This is the RPG programming on IBM i (RPG400-L) mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/rpg400-l.
>
> Please contact support@xxxxxxxxxxxx for any subscription related
> questions.
>
> Help support midrange.com by shopping at amazon.com with our affiliate
> link: https://amazon.midrange.com
>
> --
> This is the RPG programming on IBM i (RPG400-L) mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/rpg400-l.
>
> Please contact support@xxxxxxxxxxxx for any subscription related
> questions.
>
> Help support midrange.com by shopping at amazon.com with our affiliate
> link: https://amazon.midrange.com