When I copy a table, which has nullable columns, rows are rejected.
How can I easily copy nullable columns?

Please provide DB2 version, OS, DDL of source table, DDL of target table and SQL you are using to copy.

Andy

DB2 8.2
OS win32
I can copy all tables except tables which have nullable columns.
first I couldnt copy tables which have auto generated identity but then using alter ....set generated by default db2command it is okey.But now can not copying nullable columns

How are you doing the copy. Please give specific detail. Your general description is not helpful. The DDl for the source, destination, and SQL you use to copy would help alot.

Andy

I'm copying tables from one db to another db by sending db2 commands to db2clp from my .net application.
first I set the auto generate identity to generated by default by using alter command.
then export table with export command.
then import tables into new db with import command
I need db2command to copy tables contains columns that are nullable.I get this from this error:

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.

Set it to "GENERATED ALWAYS BY DEFAULT"

You had a related question last week. Are you sure you are setting the identity on the destination properly, or are you doing that on the source. The message you are getting has to do with the column still being generate always. The nullable part has nothing to do with the message you are getting. What is the reason for the copy?

Andy

yer you are right.error is about aouto generate.it is okey now.thank you very much