Start of change

-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

End of change