logo  
Google
 

DB2 SQL-Error: -769

SQLState: 428C9

Short Description: C E SQL YOU CANNOT INSERT A VALUE INTO A COLUMN THAT IS DEFINED WITH THE OPTION GENERATED ALWAYS COLUMN NAME

When inserting into a table, a value was specified for column column-name with the GENERATE ALWAYS attribute. GENERATED ALWAYS columns should not be specified in the column-list for an insertion unless the corresponding entry in the VALUES list is DEFAULT. System action: The INSERT is not performed. Programmer response: Remove the column from the column-list or specify DEFAULT for the GENERATED ALWAYS column in the VALUES clause. You can also use the OVERRIDING clause as a possible solution for this situation. See INSERT in DB2 SQL Reference for more information about the OVERRIDING USER VALUE clause.

 <-  BACK TO INDEX