Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2015

    Unanswered: Db2 import command

    Hi, I am finding hard to load data from CSV to DB. I have a table with composite primary key, say column B and A in (columns A,B,C,D). We need to import the file every month, and some of the data in file just need updates to DB and some of them are new. If composite primary key already present in DB, We need to update data to DB otherwise, insert them. Could someone help me with the insert/insert_update command ?

  2. #2
    Join Date
    Apr 2012
    Provided Answers: 17
    Are you using the INSERT_UPDATE option on the Import command? If so, what problem are you having, and also post DB2 version+fixpack + operating system name.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts