FAQ - Frequently Asked Questions

The contents of these columns appear on the DB2 log normally just like any other value. Therefore, if an INSERT statement is generated, it will contain this column. This has to be taken into consideration if the INSERT statement is supposed to be executed against a target table. It is recommended to remove the GENERATED ALWAYS clause from the target table’s column because it is important that the row receives the same value for the column in question. Otherwise, subsequent UPDATE or DELETE operations may cause the wrong target row to be affected.