DB2 Error Code – -840 too many items returned in a select or insert list

In this post, you’ll learn about the error message -840 too many items returned in a select or insert list in the IBM DB2 database , the reason why it occurs along with the solution to fix it

IBM DB2 Error Message

-840 too many items returned in a select or insert list

Reason for the Error

The number of items returned in the select list or presented in an insert list exceeds the allowable maximum of 750.

Solution

Determine whether all the information is actually needed.� (Note that the number of items returned by the select list * in the SQL statement SELECT * FROM A, B, C is the sum of the number of columns in all three tables.)� If not, rewrite the SQL statement so that only the necessary items of information are returned.� If so, break the SQL statement up into two or more statements, as required.