This content has been marked as final.
Show 1 reply
-
1. Re: Saving blob/varbinary to file from VDB.
shawkins Sep 13, 2015 1:39 PM (in response to xyran)> Does Red hat virtualization has any build in functions to query the VDB and save varbinary content to a file? Like SQL server's
bcp
or Oracle'sUTL_FILE.
There is the file translator that exposes procedures for reading and writing files - File Translator - Teiid 8.12 (draft) - Project Documentation Editor
> Also on UDF, should all the functions need to have a return type? and how to handle any exception within UDF?
Yes it is expected that that UDFs are scalar / aggregate functions that return a value. As for the exception handling, any exception thrown will get converted to a Teiid SQL exception. If the exception thrown is a SQLException, then we'll propagate the error/vendor code.