logo  
Google
 

DB2 SQL-Error: -399

SQLState: 22511

Short Description: INVALID VALUE ROWID WAS SPECIFIED

When inserting into a table, a value specified for a ROWID column was invalid. Only row ID values previously generated by DB2 are valid. System action: The statement cannot be executed. System programmer response: Do not attempt to generate any value into a ROWID column. Insertion into ROWID columns is supported for purposes of Data Propagation, where DB2 has previously generated the row ID values. Only row ID values previously generated by DB2 can be used as values for insertion into a row ID column. Alternatively, insert the row specifying DEFAULT for the ROWID column or remove the ROWID column from the insert column-list. You could 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