Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2012
    Posts
    8

    Unanswered: LOAD REPLACE utility

    Hi,

    I have to load the data from the file into the table.

    How to use LOAD REPLACE for the load utility ...
    current am using
    LOAD CLIENT FROM file.ixf OF ixf INSERT INTO TABLE NONRECOVERABLE INDEXING MODE REBUILD ALLOW NO ACCESS

    But how can i use load replace here..instead of insert

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Read the manual:

    IBM DB2 9.5 Information Center for Linux, UNIX, and Windows

    Use REPLACE instead of INSERT.

    Andy

Posting Permissions

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