SQL3550W: Import for generated column rejected

Problem:

HCO Import is loading a .DSN which includes a generated identity column.

The dataset to load contains values of the generated columns. Those values will be loaded by default, but should be generated. If no generated column-related file type modifiers are used, the import utility works according to the following rules:

A value will be generated for a generated column whenever the corresponding row in the input file is missing a value for the column, or a NULL value is explicitly given. If a non-NULL value is supplied for a generated column, the row is rejected (SQL3550W).

Resolution:

You have to set the identityignore modifier in the Import options.