Getting "SQLSTATE 01003 message" for each row if max/min generate NULL values (4332894)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

Getting "SQLSTATE 01003 message" for each row if max/min generate NULL values
Description

Getting "SQLSTATE 01003 message" for each row if max/min generate NULL values
Cause

This message is a warning message (not error) that occurs when a column function is used in an expression. For example, "select sum(salary) from employee" and the column contains a row with NULL.
This happens because Column functions are designed to ignore nulls.

For more information about this and how to troubleshoot it from the DB2 see please see this link.
Resolution

WORKAROUND

Disable "Connection Output" option in the Results | Messages tab

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title