logo  
Google
 

DB2 SQL-Error: -397

SQLState: 428D3

Short Description: GENERATED IS SPECIFIED WITH A COLUMN THAT IS NOT A ROW ID A DISTINCT TYPE BASED ON A ROW ID OR AN IDENTITY COLUMN

GENERATED was specified in a CREATE or ALTER TABLE statement for a column with a data type that is not a row ID, a distinct type that is based on a row ID, or an identity column. GENERATED can only be specified for a column with a data type of row ID, a distinct type that is based on a row ID, or an identity column. System action: The statement cannot be processed. Programmer response: Correct the statement. Either eliminate the GENERATED clause or change the data type of the column ensure that the data type of the object is row ID, or that the column is an identity column

 <-  BACK TO INDEX