This content has been marked as final.
Show 2 replies
-
1. Re: CLOB to string
rareddy Jul 11, 2012 12:34 PM (in response to mlopezal)Look in the Teiid Reference Guide for all the Function library. I am thinking the below will work.
https://docs.jboss.org/author/display/TEIID/Type+Conversion+Functions
https://docs.jboss.org/author/display/TEIID/String+Functions
SELECT CONVERT(TO_CHARS(z.result, 'UTF-8'), string) FROM (EXEC FreebaseTrans.invokeHttp(action => 'GET', endpoint => VARIABLES.INPUT_ENDPOINT)) AS z
Ramesh..
-