Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2006
    Posts
    104

    Unanswered: Selective import

    Hi

    DB2 8.2.6 on windows 2000

    We have an archives of large hsitory table with blobs. The archive is an export in ixf format of the table. There is a requirement to select specific rows for import. Is there a way to do this?

    Thanks

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    There is no direct way using DB2 tools or commands. What I would suggest is that you create a dummy table just like the one you want to import into. Use DB2 LOAD to put all the data into it. Then use SQL INSERT to copy just the rows you want.

    HTH

    Andy

  3. #3
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    Another idea to avoid the copying is to create a view over the table, put an INSTEAD OF INSERT trigger on that view and then import into the view. The trigger can filter out the rows that you don't want to have.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

Posting Permissions

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