Loading Identity Columns

[Bob DiMonte]

Have some generated columns in a table. did and export of ixf type and ran:

load from d:\dba\test_stu dents.ixf of ixf modified by identityoverrid e messages d:\dba\test_stu dents_imp3.txt insert into test.students_l ive;

but still get rows rejected with SQL3550W The field value in row "F0-1" and column "12" is not NULL, but the
target column has been defined as GENERATED ALWAYS.

This is on DB2 V 8.2.

Any ideas will be helpful.

[Purple]

Hi Bob,

I am going to move this to the forum because you have posted it in the articles section.

MODERATOR