-399   INVALID VALUE ROWID WAS SPECIFIED

Explanation

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 processed.

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. For more information about the OVERRIDING USER VALUE clause, see INSERT.

SQLSTATE

22511