Informix ODBC and Query Folding

[jirim]

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?

[v-luwang-msft]

Hi @jirim ，

Has your problem been solved, if so, please consider Accept a correct reply as the solution or share your own solution to help others find it.

Best Regards
Lucien

[v-luwang-msft]

Hi  @jirim ，

This seems strange - it might be worth seeing whether query folding is taking place, and what your OData source actually returns, by using this technique: https://blog.crossjoin.co.uk/2018/05/03/troubleshooting-data-refresh-performance-issues-with-odata-d...

Best Regards

Lucien