-397 GENERATED IS SPECIFIED AS PART OF A COLUMN DEFINITION, BUT IT IS NOT VALID FOR THE DEFINITION OF THE COLUMN
Explanation
In a CREATE TABLE statement or ALTER TABLE statement, GENERATED was specified for a column type that does not support generated values. GENERATED can be specified only for a column with one of the following data types:
- Row ID
- Distinct type that is based on a row ID
- Row change timestamp
- Identity column
- Row-begin column
- Row-end column
- Transaction-start-ID column
System action
The statement cannot be processed.
Programmer response
Correct the statement. Either remove the GENERATED clause or change the definition of the column to one of the types that can be generated.
SQLSTATE
428D3