Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2004
    Location
    USA
    Posts
    6

    Unanswered: DB2 Table Export - LOAD & UNLOAD ?

    Hello All,

    I want to export a DB2 table from one database to another database. Do any one know how to export a table?

    One of the data type for my table is a BLOB, so it is causing some problem. I saw some utilities like LOAD and UNLOAD to perform table export.

    Did anyone tried these tools? Suggestions are very helpful.

    Thanks.

  2. #2
    Join Date
    Mar 2004
    Location
    Toronto, ON, Canada
    Posts
    513
    Quote Originally Posted by rkmarthy
    Hello All,

    I want to export a DB2 table from one database to another database. Do any one know how to export a table?

    One of the data type for my table is a BLOB, so it is causing some problem. I saw some utilities like LOAD and UNLOAD to perform table export.

    Did anyone tried these tools? Suggestions are very helpful.

    Thanks.
    I think you want EXPORT and LOAD... you'll probably want to use LOBS TO lob-path on the EXPORT and "modified by LOBSINFILE" in the LOAD.

    (Read the guidelines for posting, too, since I'm just guessing your platform, version, etc...)
    --
    Jonathan Petruk
    DB2 Database Consultant

Posting Permissions

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