CLOB and BLOB

n_vishwanatha
n_vishwanatha used Ask the Experts™
on
Hi ,

I am getting following error , Please help me in Export and import and inserting the CLob and blob values in the db2 .

$ db2 "export to ADVISE_INDES.ixf of ixf select * from DB2INST4.ADVISE_INDEX"
SQL3132W  The character data in column "COLNAMES" will be truncated to size
"32700".

SQL3132W  The character data in column "CREATION_TEXT" will be truncated to
size "32700".

SQL3132W  The character data in column "PACKED_DESC" will be truncated to size
"32700".

SQL3104N  The Export utility is beginning to export data to file
"ADVISE_INDES.ixf".

SQL3105N  The Export utility has finished exporting "18" rows.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
you need to export the lob values to a different file i guess
I Found Solution As Follows
Export :
db2 "export to ADVISE_INDES.ixf of ixf LOBS TO '/home/db2inst4/Lobs' LOBFILE lOBFILES messages message.txt SELECT * FROM DB2INST4.ADVISE_INDEX"
Import :
db2 "import From ADVISE_INDES.ixf of ixf LOBS from '/home/db2inst4/lobs'  ALLOW WRITE ACCESS COMMITCOUNT 10 MESSAGES messageImort.txt INSERT into TEST.ADVISE_INDEX"
 

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