db2move

[Terry]

Hi All,

Im attempting to use db2move from 7.1.0 to 8.1.4. It fails to import
tables defined using the columns with GENERATED ALWAYS.

The error message generated follows:
"SQL3550W The field value in row "1" and column "1" is not NULL, but
the target column has been defined as GENERATED ALWAYS.

SQL3550W The field value in row "2" and column "1" is not NULL, but
the target column has been defined as GENERATED ALWAYS.

etc…"

Any suggestions on how to get around this issue?

Thanks

Terry

[Ian]

Terry wrote:

Hi All,

Im attempting to use db2move from 7.1.0 to 8.1.4. It fails to import
tables defined using the columns with GENERATED ALWAYS.

Any suggestions on how to get around this issue?

db2move is a handy utility, but it has a lot of limitations if your
schema has RI, generated columns, etc.

With that in mind:

1) Execute LOAD manually for the table(s) that have GENERATED ALWAYS
(see the identityignore file-type modifier)

2) Consider GENERATED BY DEFAULT (ugh)