Say you have SELECT SUM(x)/SUM(y) FROM ...

We're using a DB2 DB from Java and the exception we see is not useful for knowing that a divide-by-0 has happended, and we want to know this. What can we do to a)trap the problem and b)signal it?

Thanks a lot.

SELECT CASE WHEN COALESCE(SUM(y),0)=0 THEN NULL
ELSE SUM(x)/SUM(y) END
FROM ...

Is ther an equivalent of SQL Servers NullIf () function in DB2?

how would you use NULLIF here? are you sure you don't mean ISNULL?

Like this: