<div>
you need to export the lob values to a different file i guess
</div>


you need to export the lob values to a different file i guess

<div>
<div class="content wysiwyg-content">
Hi , <br />
<br />
I am getting following error , Please help me in Export and import and inserting the CLob and blob values in the db2 . <br />
<br />
<b>$ db2 &quot;export to ADVISE_INDES.ixf of ixf select * from DB2INST4.ADVISE_INDEX&quot;<br />
SQL3132W &nbsp;The character data in column &quot;COLNAMES&quot; will be truncated to size<br />
&quot;32700&quot;.<br />
<br />
SQL3132W &nbsp;The character data in column &quot;CREATION_TEXT&quot; will be truncated to<br />
size &quot;32700&quot;.<br />
<br />
SQL3132W &nbsp;The character data in column &quot;PACKED_DESC&quot; will be truncated to size<br />
&quot;32700&quot;.<br />
<br />
SQL3104N &nbsp;The Export utility is beginning to export data to file<br />
&quot;ADVISE_INDES.ixf&quot;.<br />
<br />
SQL3105N &nbsp;The Export utility has finished exporting &quot;18&quot; rows.</b>
</div>
</div>


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.

CLOB and BLOB

IBM DB2 is a family of relational database server products developed by IBM that have been extended to support object-relational features and non-relational structures like JSON and XML. There are three main products in the DB2 family: DB2 for Linux, UNIX and Windows (informally known as DB2 LUW), DB2 for z/OS (mainframe), and DB2 for i (formerly OS/400), plus a version for IBM's Virtual Storage Extended (VSE) operating system.