var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: export clob data to single file
we are using DB2 v9.1.6, we need to export data from table having clob column to single file
here is the tables:
CREATE TABLE ABC.TEST (
TEST_ID INTEGER GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1, CACHE 20) NOT NULL,
db2 export to TEST.del of del modified by lobsinfile messages Test.msg SELECT * FROM ABC.TEST;
Problem is since the CLOB value exceeds 32K we need to store CLOB data in different file but we don't want this to happen.
Is there any way we can export CLOB data to single file ?
Any suggestion is appreciated.
You can only export up to 32KB of LOB data inline