You want to read from the BLOB or do you want to write the IFS File?
File Operation SQFOVR means, an IFS file gets created if it does not yet
exist and if it already exists it is replaced.
If you want to read from an IFS file you need the file operation SQFRD.
Mit freundlichen Grüßen / Best regards
Birgitta Hauser
"Shoot for the moon, even if you miss, you'll land among the stars." (Les
Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them? Not training them
and keeping them!"
?Train people well enough so they can leave, treat them well enough so they
don't want to.? (Richard Branson)
-----Original Message-----
From: RPG400-L <rpg400-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Art
Tostaine, Jr.
Sent: Sonntag, 23. Juni 2019 17:58
To: RPG programming on the IBM i (AS/400 and iSeries)
<rpg400-l@xxxxxxxxxxxxxxxxxx>
Subject: Problem retrieving BLOB using SQLRPGLE
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
midrange.com
