Export and import

n_vishwanatha
n_vishwanatha used Ask the Experts™
on
Hi ,

 db2 describe table ADVISE_INDEX

CREATION_TEXT                   SYSIBM    CLOB                   2097152
PACKED_DESC                     SYSIBM    BLOB                   1048576    

Please help me in  Exporting and importing CLOB and BLOB in the db2 .

Thanks and regards
Vishwanatha N
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
exporting is pretty easy, just use the export statement with lobs to, for example

look here for more reference and examples
http://publib.boulder.ibm.com/infocenter/db2luw/v9r7/topic/com.ibm.db2.luw.admin.cmd.doc/doc/r0008303.html

db2 export to myfile.del of del
      lobs to /db2exp1/, /db2exp2/ modified by lobsinfile
      select * from emp_photo


do you want to import from the file you generate with export or from an external source?

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial