logo  
Google
 

DB2 SQL-Error: -840

SQLState: 54004

Short Description: TOO MANY ITEMS RETURNED IN A SELECT OR INSERT LIST C E SQL I SQL

The number of items returned in the select list or presented in an insert list exceeds the allowable maximum of 750. System action: The statement cannot be executed. Programmer response: 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

 <-  BACK TO INDEX