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.
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.