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


  1.  Home
  2. RPG400-L
  3. June 2015

Re: Pass file into RPGLE via stored procedure?

On 16-Jun-2015 11:26 -0600, Justin Taylor wrote:

I can't seem to get the compiler to take a BLOB_LOCATOR as an input
parameter.

Dcl-pr testBlobSP ;
textIn varChar(256);
myBlob SQLTYPE(BLOB_LOCATOR);
RNF3438: LIKE keyword is expected for field but not found;
definition is ignored.
RNF3308: Keyword name is not valid; the keyword is ignored.
End-pr ;


The doc reference shows what the pre-compiler does to the SQLTYPE. So if SQLTYPE is not being accepted [or is disallowed] on the parameter declarative, then I would circumvent by either declaring a template variable and use the LIKE as suggested by the msg RNF3438 or just code directly the [IIRC] 10U00 declarative for the myBlob blob_locator variable.


As an Amazon Associate we earn from qualifying purchases.

This thread ...
Replies:
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

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.