ODBC-native-escape clause

Community Support
1

Hi,

In Simba ODBC driver documention says:

“In the Edit Custom SQL dialog box, write a SQL statement that includes an
ODBC-native-escape clause containing your q query. For more information, see
“Native Syntax” in the ODBC 4.0 Specification”

Could some kindly tell me what is ODBC-native-escape clause with the Simba driver. I have googled a bit and I haven’t find out the solution?

Best regards,

Kimmo

2

I also have this same question trying to use Simba to connect to Tableau. Everything I’ve read about escape clauses is about funny data types like dates or times and mentions wrapping them in {} but that didn’t seem to work for me.

So like {select from mytable} doesn’t work and nor does SELECT * FROM {select from mytable}

When I select an entire table and “convert” it to custom SQL it gives me syntax like the below, although I’d also like to add a where clause and ideally a bunch of other stuff and just write a normal query in Q: 

SELECT “tablename”.“field1” as “field1”,

“tablename”.“field2” as "field2

…

FROM “ROOT”.“tablename” “tablename”

3

Hi   

This just came up from another user this week and wanted to share the example I did with them in case you are still trying this :

 

//For table t t:(c1:10?100;c2:10?AABBCCDD) //To run a simple q-sql call you can use { native ‘select from t where c2=`DD’ COLUMNS()} //For process defined functions such as foo:{(c1:enl x;c2:enl y)} //You can call this through the SIMBA driver using { native ‘foo’ PASSING(‘{a}’:symbol,‘{1}’:long) COLUMNS() } //Although I believe you can just replace foo with any lambda, as long as the return is in the form of a table. { native ‘{(c1:enl x;c2:enl y)}’ PASSING(‘{a}’:symbol,‘{1}’:long) COLUMNS() }

 

 

It requires this native syntax https://github.com/Microsoft/ODBC-Specification/blob/master/ODBC%204.0.md#3354-native-syntax