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...)