ANR2947E
Division by zero was detected for operator 'operator'.

Explanation

An attempt to divide by the number zero was detected for the specified SQL operator. The most likely cause of the problem is that one of the values of a column is zero, and that column is used in the denominator of a division operation. To protect against this case the NULLIF function can be used. For example, instead of the expression 1/X, specify 1/NULLIF(X,0), which will set the expression to null whenever the value if X is zero.

System action

The SQL query is terminated.

User response

None.