[DERBY-378] support for import/export of tables with clob/blob and the other binary data types will be good addition to derby,

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 10.1.1.0
• Fix Version/s: 10.3.1.4
• Component/s: Tools
• Assignee: Suresh Thalamati
• Reporter: Suresh Thalamati
• Created: 21/Jun/05 06:46
• Updated: 19/Nov/13 13:26
• Resolved: 23/May/07 23:55

Description

Currently if I have a table that contains clob/blob column, import/export operations on that table
throghs unsupported feature exception.

set schema iep;
set schema iep;
create table ntype(a int , ct CLOB(1024));
create table ntype1(bt BLOB(1024) , a int);

call SYSCS_UTIL.SYSCS_EXPORT_TABLE ('iep', 'ntype' , 'extinout/ntype.dat' ,
null, null, null) ;
ERROR XIE0B: Column 'CT' in the table is of type CLOB, it is not supported by th
e import/export feature.

Issue Links

• is blocked by: DERBY-2864 LOB import unexpectedly succeeds on corrupt data
• is related to: DERBY-2859 Misleading error message if you supply too many arguments to SYSCS_UTIL.SYSCS_EXPORT_QUERY_LOBS_TO_EXTFILE
• is related to: DERBY-2860 Documentation problems for IMPORT/EXPORT LOBs feature
• relates to: DERBY-2527 Add documentation for import/export of LOBS and other binary data types.