cancel
Showing results for 
Search instead for 
Did you mean: 

Why is IfThenElse get pushed down if datastore's Database type was ODBC ?

Former Member
0 Kudos

I discovered that my DF is not getting pushed down to database server and the reason is I was using IfThenElse function which can not be converted to equivalent SQL by DS.

After hours researching, I found out that this issue can not be resolved because I'm setting my datastore like this :

In order to convert IfThenElse function to SQL, the option IfThenElse support must be Yes, but only when I set the Database Type to ODBC, that option appears.

My question is, Why isn't IfThenElse get pushed down if datastore's Database type wasn't ODBC ?

Accepted Solutions (0)

Answers (0)