By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,007 Members | 1,248 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,007 IT Pros & Developers. It's quick & easy.

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

P: n/a
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 .

Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Alias wrote:
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.

--
Knut Stolze
Information Integration
IBM Germany / University of Jena
Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.