CODEWITHSUNDEEP
csvimportdb2
Genny
Genny

Reputation: 71

db2 import from file csv

I made a simple example, but it does not work. I connect to sample database

my file is ABC.csv

1;2

2;3

db2 import from "ABC.csv" OF DEL insert into abc(id,id2)

the import found the rows and it says that inserted.

but if db2 select * from abc no numbers appear but '-'

example

id id2

_ _

_ _

why?

the table abc is create as (id int, id2 int)

Upvotes: 0

Views: 24716

Answers (1)

data_henrik
data_henrik

Reputation: 17118

Make sure that you either use the standard delimiter (comma, ",") in your data file or to adapt the delimiter using the COLDEL parameter.

db2 import from "ABC.csv" OF DEL MODIFIED BY COLDEL; insert into abc(id,id2)

Upvotes: 2

Related Questions