COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: devardekartb on 27 Mar 2015 10:53:42 AM

Title: Getting nullif error while testing reports
Post by: devardekartb on 27 Mar 2015 10:53:42 AM
I was looking into one issue and found that one query is having expression (1/column name) where native sql is applying nullif function to handle 0, if it comes.

Current DB2 ODBC driver connection is not capable to handle it and query is throwing error.

I tried to modify the expression so that nullif function will not apply but whenever we have 1 divided by some value, null if function automatically added.

If anybody has any view on this, please share.