Skip to Content
avatar image
Former Member

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

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)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers