Re: Problem retrieving BLOB using SQLRPGLE

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