Re: Return BLOB from Stored Procedure

The stored proc would be called by a Coldfusion server via JDBC, which
would extract the PDF for display to the user.

I don't want to expose the UNC to the file. A web service might work,
but the rest of the interface between CF and the i is via stored
procs. It be nice not to have to add anything new.

Charles

On Fri, Feb 13, 2009 at 9:41 AM, Walden H. Leverich
<WaldenL@xxxxxxxxxxxxxxx> wrote:

I've got a .PDF file in the IFS I want to return as a BLOB column in a
result set from a stored procedure.

Return it to what? Databases are good for, um, data, file systems for,
um, files. Can you return either a UNC path to the file
(\\server\share\folder\file.pdf) or use a web service where you can
stream the results directly to the client?

-Walden

--
Walden H Leverich III
Tech Software
(516) 627-3800 x3051
WaldenL@xxxxxxxxxxxxxxx
http://www.TechSoftInc.com

Quiquid latine dictum sit altum viditur.
(Whatever is said in Latin seems profound.)
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.