返回
-
标题
Getting "SQLSTATE 01003 message" for each row if max/min generate NULL values -
说明
Getting "SQLSTATE 01003 message" for each row if max/min generate NULL values -
原因
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.
-
解决办法
WORKAROUND
Disable "Connection Output" option in the Results | Messages tab
