EXPORT, Change the CLOB and then IMPORT

[db2dbdba]

Hi All,

I am working in DB2 and trying to export data from a table.
DDL for my table is

CREATE TABLE "CMMETA  "."CMREF"  (
		  "SITECODE" SMALLINT , 
		  "CMPNTKEY" CHAR(32) , 
		  "CMPNTKIND" SMALLINT , 
		  "UPDT_TS" TIMESTAMP , 
		  "CMPNTVALUE" CLOB(32700) LOGGED NOT COMPACT )   
		 IN "USERSPACE1" ;

I have to add some content to the CLOB column and then have to put it back into the table. But I am not able to put the whole data back into the table using import. that is destroying my webpage alignment.

CLOB contains a HTML code for a webpage.

I am editing the lob file through textpad before importing it.

I am using DB2 v8.1.2.96" FixPak10 on Linux

Please help me and Thanks a lot in advance

R

[db2dbdba]

Hi All,

I am working in DB2 and trying to export data from a table.
DDL for my table is

CREATE TABLE "CMMETA  "."CMREF"  (
		  "SITECODE" SMALLINT , 
		  "CMPNTKEY" CHAR(32) , 
		  "CMPNTKIND" SMALLINT , 
		  "UPDT_TS" TIMESTAMP , 
		  "CMPNTVALUE" CLOB(32700) LOGGED NOT COMPACT )   
		 IN "USERSPACE1" ;

I have to add some content to the CLOB column and then have to put it back into the table. But I am not able to put the whole data back into the table using import. that is destroying my webpage alignment.

CLOB contains a HTML code for a webpage.

I am editing the lob file through textpad before importing it.

I am using DB2 v8.1.2.96" FixPak10 on Linux

Please help me and Thanks a lot in advance

R

Hi,

I have figured out the mistake in my process.
I didn't update the size of file in LLS and when I added content to the LOB.

But I am still wondering why I am getting this error when I change the LOB and import it.

SQL3040N  Unable to use the lobpath/lobfile parameters as specified. Reason
code: "6".

Please help me.

Thanks,
R

[docdiesel]

Hi,

error SQL3040N with reason code 6 says in the IBM docs "An error occurred while trying to access the file" as reason. Does the load/import process have reading rights on the file?

You mentioned editing it with textpad. That sound like editing the file on Windows and trying to load it in Linux DB2. Are you loading directly from the Windows to the Linux system or transfering it (e.g. via ftp) before loading it natively on the Linux server? Remember that Linux uses just a LF (0x0A) as line separator while window$ uses CRLF (0x0D0A). Means textpad could place CRLF where LF has been which may upset the Linux DB2.

Regards,

Bernd