how to copy a clob column data......

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Alias - 29 Apr 2005 15:10 GMT

Hi Guys ,
We have a table(say A) with one clob column . Some data from
this table needs to be archived from time to time . My question is if i
use :

insert into archive_table select * from A where <condition> ;

Will it insert everything including complete clob data from A into
archive_table ( assuming both the tables are exactly similar in
structure) or is their a special way to treat CLOB values ?

Thanks in advance for the help .

Reply to this Message

Knut Stolze - 30 Apr 2005 06:19 GMT

> Hi Guys ,
> We have a table(say A) with one clob column . Some data from
> this table needs to be archived from time to time . My question is if i
> use :
>
> insert into archive_table select * from A where <condition> ;

It will just work - why do you think it might not?

> Will it insert everything including complete clob data from A into
> archive_table ( assuming both the tables are exactly similar in
> structure) or is their a special way to treat CLOB values ?

CLOBs (or structured types or distinct types) are like any other type in DB2
and DB2 will take care of it as if it were an integer. The basic
difference is merely that an integer has 4 bytes and a LOB is a bit bigger.

Signature

Knut Stolze
Information Integration
IBM Germany / University of Jena

Reply to this Message