Skip to Content
avatar image
Former Member

SAP DS is not pushing down ifthenelse or decode()

I'm designing a DS JOB targeting a SybaseIQ and realize that IfthenElse Syntax and DI Decode() function are not getting pushed down to the database server.

Is there any equivalent DI function that I can use to push the whole operation down to Sybase IQ server ?

I'm checking if the DF is getting pushed down to sybase using Validation -> View Optimized SQL

SAPDS : 14.2.3.549

SybaseIQ 16

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Apr 11 at 06:18 AM

    Apparently DS BODI won't be able to convert ifthenelse function to SybaseIQ's SQL format query if the database type is set to SybaseIQ in the datastore's setting. If I change the database type to ODBC then the next thing I have to do is to change the option `ifthenelse support` to `Yes` and voila, the operation will be pushed down to SQL Server. Unfortunately, I'm not allowed to edit the datastore's setting ... so I think I will have to cope with this until this issue is fixed by SAP then.

    Add comment
    10|10000 characters needed characters exceeded