The Unquote function as shown below no longer works in the SQL of TDP 3.6. When I try it, it does let me enter the variable prompt, but then I get the error: Token : was not valid. Valid tokens: ( NEW FINAL TABLE UNNEST LATERAL XMLABLE . "
This is running an ODBC connection to a DB2 query. I still have a copy of TDP 3.4 and I run this same exact query using this unquote function in it, and it works perfectly fine. I looked at new documentation and I have everything exactly the same and I’m wondering if others are getting the same issue when using variables in this unquote function in TDP 3.6?