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.
...
Bob DiMonte
Last Activity: Sep 13 '07, 07:52 PM
Joined: Sep 13 '07
Location:
-
DB2 Load Identity Column
-
Loading Identity Columns
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.
...
No activity results to display