Forum Discussion

jirim's avatar
jirim
Frequent Visitor
5 years ago

Informix ODBC and Query Folding

I try to connect to Informix 11 db using 64bit ODBC driver v 4.50.00.18020. I get data correctly but query folding does not work after any filter applied. If I run diagnostics on the step with simple equal filter like

 

= Table.SelectRows(my_Table, each ([field1] = "01"))

 

 I can find "OdbcQuery: FoldingWarning" that says "This ODBC driver doesn't support SQL_SP_COMPARISON. You can override this by using SqlGetInfo for SQL_SQL92_PREDICATES."

If I use BeginsWith filter like

 

= Table.SelectRows(my_Table, each Text.StartsWith([field2], "M"))

 

the warnings are following:

This ODBC driver doesn't support SQL_FN_STR_LOCATE_2. You can override this by using SqlGetInfo for SQL_STRING_FUNCTIONS.

This ODBC driver doesn't support SQL_FN_STR_LOCATE. You can override this by using SqlGetInfo for SQL_STRING_FUNCTIONS.

This ODBC driver doesn't support SQL_SP_LIKE. You can override this by using SqlGetInfo for SQL_SQL92_PREDICATES.

 

Is there any way how to fix it?

 

 

2 Replies