Monday, November 28, 2011

Inserting CVS Data to DB Using Db command


Command:
  db2 import from C:\test.csv of del insert into address    (addressId,status,nickname,firstname,lastname,email1)

Imp Points:
  • According to csv file the corresponding coloumns have to be specified for the table.
  • Have to be login to DB with Administrative Privilages.

No comments:

Post a Comment