Hi,

I want to import data from .csv file into db2 database where one column value is set to auto increment and one more column value set to current timestamp.
In this case is it required to mention these columns in .csv fiile. If yes what will be values of these. I tried with null values for these columns but is giving me following error message

SQL3120W The field value in row "1" and column "1" cannot be converted to an
INTEGER value, but the target column is not nullable. The row was not loaded.

Anybody has idea about importing in such scenario.

I m using Control Center utility for Import

See if this helps: Generated column import considerations - IBM DB2 9.7 for Linux, UNIX, and Windows