Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2012
    Posts
    1

    Unanswered: Db2 load utiltiy

    Below are my scenario:
    I want to append the new rows to the table using the load replace.and if any existing data is there and the values are changed
    in that need to update the values.what is the option i can use in load utility?

    Any help

  2. #2
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    with load : only insert or replace
    if insert-update is needed : import must be used and you need a pk
    IMPORT
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  3. #3
    Join Date
    Sep 2009
    Location
    Israel
    Posts
    4

    Good question

    It make sence to do this , but until now there is no solusion do do it with load utility.
    You can unload the current data and with syncsort to drop duplicates that are in the unload file.
    Maybe now , after we have the MERGE , in the next version it will be posible.

Posting Permissions

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