Skip to Content
0

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

Apr 11 at 08:14 AM

17

avatar image
Former Member

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 ?

sap.jpg (33.3 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers