468,257 Members | 1,316 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,257 developers. It's quick & easy.

db2move

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

Similar topics

1 post views Thread by TD Matthews | last post: by
2 posts views Thread by erkki | last post: by
4 posts views Thread by Christos Kalantzis | last post: by
reply views Thread by ibm_97 | last post: by
2 posts views Thread by Alan | last post: by
2 posts views Thread by Mani | last post: by
reply views Thread by mikeodba | last post: by
reply views Thread by NPC403 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.