If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Getting nullif error while testing reports

Started by devardekartb, 27 Mar 2015 10:53:42 AM

Previous topic - Next topic

devardekartb

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.