Export and import

n_vishwanatha used Ask the Experts™
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
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

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