By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,129 Members | 2,300 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,129 IT Pros & Developers. It's quick & easy.

db2move

P: n/a
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
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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)


Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.