Re: Return BLOB from Stored Procedure

[Pete Hall <pbhall@xxxxxxxxxxxxx>]

Haven't played with them much, but a UDTF (user defined table function)
might work, although I've no idea what the impact of the blob datatype
would be on that. You might try googling for UDTF. There are several
examples from systeminetwork and mcpressonline as well as the
midrange.com archive.

Charles Wilt wrote:
> All,
>
> 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.
>
> Stored procedure can be written in SQL or RPG, it doesn't matter.
> (Thus the cross post, sorry David :)
>
> The stored procedure will return just a single row.
>
> Can I do this directly without loading the BLOB column into a temporary table?
>
> Links and/or examples appreciated.
>
>
> Thanks!
> Charles