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.