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

["Brian Bonner (JIRA)" <de...@db.apache.org>]

    [ http://issues.apache.org/jira/browse/DERBY-378?page=comments#action_12319071 ] 

Brian Bonner commented on DERBY-378:
------------------------------------

I agree with Suresh.  There needs to be a way to import and export data from clobs/blobs.

> support for  import/export  of  tables with clob/blob and the other binary data types   will be good addition to derby,
> -----------------------------------------------------------------------------------------------------------------------
>
>          Key: DERBY-378
>          URL: http://issues.apache.org/jira/browse/DERBY-378
>      Project: Derby
>         Type: Improvement
>   Components: Tools
>     Versions: 10.1.1.0
>     Reporter: Suresh Thalamati

>
> 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.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira