How did you try to define the LOB Variables or LOB Files in your RPG
program/prototype?
Why would you pass a LOB instead of accessing it directly.
I'm not quite sure what you really want.
If you want to access an LOB or XML file you may use one of the functions
GET_CLOB_FROM_FILE, GET_DBCLOB_FROM_FILE, GET_BLOB_FROM_FILE or
GET_XML_FILE. To get a locator (kind of pointer) on the data. Locators can
be accessed and handled with SQL functions like any character (single or
double byte) or XML field, i.e. you can use SUBSTR, POSSTR etc. functions.
As an aside the GET_xCLOB functions must be performed under commitment
control.
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!"
-----Ursprüngliche Nachricht-----
Von: RPG400-L [mailto:rpg400-l-bounces@xxxxxxxxxxxx] Im Auftrag von Justin
Taylor
Gesendet: Monday, 15.6 2015 23:39
An: rpg400-l@xxxxxxxxxxxx
Betreff: RE: Pass file into RPGLE via stored procedure?
John Yeung,
Yes, if they were so inclined an alternative file transfer method could
certainly be set up. This is mainly a philosophical change on their part.
They insist that every call be completely self-contained.
Alan Campin,
I was hoping I could pass some kind of LOB but RPGLE doesn't seem to like
that.
I'm already handling ZIP files, so that's not a problem. I extract it,
process the contents and then delete it.
--
This is the RPG programming on the IBM i (AS/400 and iSeries) (RPG400-L)
mailing list To post a message email: RPG400-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/rpg400-l.
midrange.com
