Import CSV not working in primary keys

kirubamatrix · #1 (**permalink**) 11-19-09, 07:30

Hi,

I have a csv file and when I import into the DB2, it gets imported.

But, when there is a primary key in the column of the same table, the value does not get imported.

I need your suggestions

the command I used is IMPORT from "d:\\gg1.csv" of DEL INSERT INTO EMPLOYEE

sathyaram_s · #2 (**permalink**) 11-19-09, 08:51

DB2 Database for Linux, UNIX, and Windows

lookout for identityignore , identitymissing on this page

Cheers
Sathyaram

Marcus_A · #3 (**permalink**) 11-19-09, 09:08

You can also alter your identity column to be "generated by default" instead of "generated always".

kirubamatrix · #4 (**permalink**) 11-20-09, 01:07

Hi Thanks for your suggestions, friends.

Now I face new problem.

I have number datatype in oracle

similarly smallint in db2

when i convert the datas it comes as a null value....

need suggestions...

(What will be the appropriate to convert number data type in oracle to db2??)

Internet Services

Web Development

Digital Marketing

Consumer Tech