Re: Pass file into RPGLE via stored procedure?

[Scott Klement <rpg400-l@xxxxxxxxxxxxxxxx>]

Justin,

Not sure if you've decided on SQL as the only possible choice here, 
but...   if you're open to other alternatives, maybe consider web services?

The HTTP protocol used in web services should be able to handle this. 
(Though, I suppose you might have to do a bit more coding than expected 
if the current crop of tooling can't do the work for you.)

-SK



On 6/16/2015 12:26 PM, Justin Taylor wrote:
> CRPence,
> 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 ;
>
>
> Booth Martin,
> The files exist on a separate server.  I'd have to use some protocol (SMB, NFS, FTP) to get them.
>
>
> Birgitta Hauser,
> I need to pass a stream file in its entirety as a parameter of a stored procedure call.  I'm open to any method of accomplishing this.