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
--
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