×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
On 15-Jun-2015 12:03 -0600, Justin Taylor wrote:
I have an RPGLE program exposed as a DB2 stored procedure. In my
RPGLE code, I go out via QNTC and access files on a Windows share.
Our Windows team is shutting down that share so I need another way to
get those files. My direction is to bring the files in as part of
the stored procedure call. The files are either text or binary (ZIP
files). Stored procedures allow a data type of BLOB, but the RPGLE
compiler says I can't have BLOB's as parameters.
Any ideas?
Perhaps using a LOB-locator for the parameter [with the file passed
as a BLOB argument by the client], and then extract that
binary-file-data to a stream file identified using a file-reference
variable?
[
http://www.ibm.com/support/knowledgecenter/api/content/ssw_ibm_i_71/rzajp/rzajplobvar.htm]
_Declaring LOB host variables in ILE RPG applications that use SQL_
"ILE RPG does not have variables that correspond to the SQL data types
for LOBs (large objects).
To create host variables that can be used with these data types, use the
SQLTYPE keyword. The SQL precompiler replaces this declaration with an
ILE RPG language structure in the output source member. LOB declarations
can be either standalone or within a data structure.
..."
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact
[javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
