Insert Into Table With Generated Always

From time to time you need to insert a row of data into a table which has an identity column or a column with the definition containing GENERATED ALWAYS.

Specifying a value for the field won't work as the system wants to generated the value leaving your with an SQL error behind.

But there are ways to add a row:

  • Specifying the fields on the SQL statement excluding the identity column
  • using OVERRIDING USER VALUE
  • using OVERRIDING SYSTEM VALUE
  • using DEFAULT as the value for the identity column

See IBM Knowledge Center.