logo  
Google
 

DB2 SQL-Error: -117

SQLState: 42802

Short Description: THE NUMBER OF VALUES ASSIGNED IS NOT THE SAME AS THE NUMBER OF SPECIFIED OR IMPLIED COLUMNS

The number of insert values in the value list of the INSERT statement is not the same as the number of object columns specified. Alternatively, the number of values on the right side of an assignment in a SET assignment statement or the SET clause of an UPDATE statement does not match the number of columns on the left side. System action: The statement cannot be executed. No data was inserted into the object table. Programmer response: Correct the statement to specify one and only one value for each of the specified object columns.

 <-  BACK TO INDEX