Re: Return BLOB from Stored Procedure

You're missing the point.

The UNC path to the file is not accessible to the web client. Nor do
I want to make it accessible.

I could load the PDF into a BLOB column in a temporary table then
return a cursor to table.

I simply want to know if there's any way to bypass the insertion of
the PDF into the temporary table. In other words, build the result
set with a BLOB column in memory and pass that back using SET RESULT
SETS or similar.

Charles


On Fri, Feb 13, 2009 at 10:32 AM, Jason Abreu <abreuj@xxxxxxxxxxxxxxxxx> wrote:

Of course you can return a BLOB (Binary Large OBject) through sql.

But, your description has nothing to do with a BLOB.
You say your PDF file is in the IFS; I'm guessing you mean stored in a
directory and not in a database table. A BLOB is a datatype for a
database table column and is returned to the calling language as a
binary stream.

Since your file is not stored within a database table, you cannot return
it as a database table column, regardless of datatype.

You will need to do what Walden suggested and store a UNC path within
the database table and return the path so your calling language knows
where to get the actual file from.

--Jason