Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
jirim
Frequent Visitor

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 2
v-luwang-msft
Community Support
Community Support

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
Community Support
Community Support

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.