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.
