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.