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


On 6/16/2015 12:26 PM, 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);
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.

As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2022 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.