db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From sure...@apache.org
Subject svn commit: r523028 [1/2] - in /db/derby/code/trunk/java: engine/org/apache/derby/catalog/ engine/org/apache/derby/impl/load/ engine/org/apache/derby/impl/sql/catalog/ testing/org/apache/derbyTesting/functionTests/master/ testing/org/apache/derbyTestin...
Date Tue, 27 Mar 2007 18:43:15 GMT
Author: suresht
Date: Tue Mar 27 11:43:14 2007
New Revision: 523028

URL: http://svn.apache.org/viewvc?view=rev&rev=523028
Log:
DERBY-378 (partial)
This patch changes the names of the new system procedures added to 
support import/export of lob data. New procedure names are :

SYSCS_UTIL.SYSCS_EXPORT_TABLE_LOBS_TO_EXTFILE(..)
SYSCS_UTIL.SYSCS_EXPORT_QUERY_LOBS_TO_EXTFILE(..)
SYSCS_UTIL.SYSCS_IMPORT_DATA_LOBS_FROM_EXTFILE(...)
SYSCS_UTIL.SYSCS_IMPORT_TABLE_LOBS_FROM_EXTFILE(..)

Removed the test cases added earlier to  ieptests.sql test 
for this issue, now those test cases are covered by the 
new junit tests. 


Modified:
    db/derby/code/trunk/java/engine/org/apache/derby/catalog/SystemProcedures.java
    db/derby/code/trunk/java/engine/org/apache/derby/impl/load/Export.java
    db/derby/code/trunk/java/engine/org/apache/derby/impl/sql/catalog/DataDictionaryImpl.java
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/ieptests.out
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/jdk16/ieptests.out
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/ieptests.out
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/jdk16/ieptests.out
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/ieptests.out
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/tools/ImportExportBaseTest.java
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/tools/ImportExportLobTest.java
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/tools/ieptests.sql
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/upgradeTests/Changes10_3.java

Modified: db/derby/code/trunk/java/engine/org/apache/derby/catalog/SystemProcedures.java
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/engine/org/apache/derby/catalog/SystemProcedures.java?view=diff&rev=523028&r1=523027&r2=523028
==============================================================================
--- db/derby/code/trunk/java/engine/org/apache/derby/catalog/SystemProcedures.java (original)
+++ db/derby/code/trunk/java/engine/org/apache/derby/catalog/SystemProcedures.java Tue Mar 27 11:43:14 2007
@@ -1135,17 +1135,17 @@
 
     /**
      * Export data from a table to given files. Large objects 
-     * are exported to a separate file and the reference to it is written 
+     * are exported to an external file and the reference to it is written 
      * in the main export file. 
      * <p>
      * Will be called by system procedure:
-     * SYSCS_EXPORT_TABLE_LOBS_IN_EXTFILE(IN SCHEMANAME  VARCHAR(128), 
+     * SYSCS_EXPORT_TABLE_LOBS_TO_EXTFILE(IN SCHEMANAME  VARCHAR(128), 
      * IN TABLENAME    VARCHAR(128),  IN FILENAME VARCHAR(32672) , 
      * IN COLUMNDELIMITER CHAR(1),  IN CHARACTERDELIMITER CHAR(1) ,  
      * IN CODESET VARCHAR(128), IN LOBSFILENAME VARCHAR(32672))
      * @exception  StandardException  Standard exception policy.
      **/
-    public static void SYSCS_EXPORT_TABLE_LOBS_IN_EXTFILE(
+    public static void SYSCS_EXPORT_TABLE_LOBS_TO_EXTFILE(
     String  schemaName,
     String  tableName,
     String  fileName,
@@ -1197,18 +1197,18 @@
 
     /**
      * Export data from a  select statement to given file. Large objects 
-     * are exported to a separate file and the reference to it is written 
+     * are exported to an external file and the reference to it is written 
      * in the main export file. 
      * <p>
      * Will be called as 
-     * SYSCS_EXPORT_QUERY_LOBS_IN_EXTFILE(IN SELECTSTATEMENT  VARCHAR(32672),
+     * SYSCS_EXPORT_QUERY_LOBS_TO_EXTFILE(IN SELECTSTATEMENT  VARCHAR(32672),
      * IN FILENAME VARCHAR(32672) , 
      * IN COLUMNDELIMITER CHAR(1),  IN CHARACTERDELIMITER CHAR(1) ,  
      * IN CODESET VARCHAR(128), IN LOBSFILENAME VARCHAR(32672))
      *
      * @exception  StandardException  Standard exception policy.
      **/
-    public static void SYSCS_EXPORT_QUERY_LOBS_IN_EXTFILE(
+    public static void SYSCS_EXPORT_QUERY_LOBS_TO_EXTFILE(
     String  selectStatement,
     String  fileName,
     String  columnDelimiter,
@@ -1273,13 +1273,13 @@
      * lob location info in the main import file. 
      * <p>
      * Will be called by system procedure as
-     * SYSCS_IMPORT_TABLE_LOBS_IN_EXTFILE(IN SCHEMANAME  VARCHAR(128), 
+     * SYSCS_IMPORT_TABLE_LOBS_FROM_EXTFILE(IN SCHEMANAME  VARCHAR(128), 
      * IN TABLENAME    VARCHAR(128),  IN FILENAME VARCHAR(32672) , 
      * IN COLUMNDELIMITER CHAR(1),  IN CHARACTERDELIMITER CHAR(1) ,  
      * IN CODESET VARCHAR(128), IN  REPLACE SMALLINT)
      * @exception  StandardException  Standard exception policy.
      **/
-    public static void SYSCS_IMPORT_TABLE_LOBS_IN_EXTFILE(
+    public static void SYSCS_IMPORT_TABLE_LOBS_FROM_EXTFILE(
     String  schemaName,
     String  tableName,
     String  fileName,
@@ -1359,7 +1359,7 @@
      * the lob location info in the main import file. 
      * <p>
      * Will be called as 
-     * SYSCS_IMPORT_DATA_LOBS_IN_EXTFILE(IN SCHEMANAME VARCHAR(128), 
+     * SYSCS_IMPORT_DATA_LOBS_FROM_EXTFILE(IN SCHEMANAME VARCHAR(128), 
      *               IN TABLENAME VARCHAR(128),
      *               IN INSERTCOLUMNLIST VARCHAR(32762), 
      *               IN COLUMNINDEXES VARCHAR(32762),
@@ -1369,7 +1369,7 @@
      *
      * @exception  StandardException  Standard exception policy.
      **/
-    public static void SYSCS_IMPORT_DATA_LOBS_IN_EXTFILE(
+    public static void SYSCS_IMPORT_DATA_LOBS_FROM_EXTFILE(
     String  schemaName,
     String  tableName,
     String  insertColumnList,

Modified: db/derby/code/trunk/java/engine/org/apache/derby/impl/load/Export.java
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/engine/org/apache/derby/impl/load/Export.java?view=diff&rev=523028&r1=523027&r2=523028
==============================================================================
--- db/derby/code/trunk/java/engine/org/apache/derby/impl/load/Export.java (original)
+++ db/derby/code/trunk/java/engine/org/apache/derby/impl/load/Export.java Tue Mar 27 11:43:14 2007
@@ -125,7 +125,7 @@
 
 	
     /**
-     * SYSCS_EXPORT_TABLE_LOBS_IN_EXTFILE system procedure from ij 
+     * SYSCS_EXPORT_TABLE_LOBS_TO_EXTFILE system procedure from ij 
      * or from a Java application invokes  this method to perform 
      * export of a table data to a file. Large object data is exported 
      * to a different file and the reference to it is stored in the
@@ -186,7 +186,7 @@
 
 
     /**
-     * SYSCS_EXPORT_QUERY_LOBS_IN_EXTFILE system Procedure from ij 
+     * SYSCS_EXPORT_QUERY_LOBS_TO_EXTFILE system Procedure from ij 
      * or from a Java application invokes this method to perform 
      * export of the data retrieved by select  statement to a file.
      * Large object data is exported to a different file  and the reference 

Modified: db/derby/code/trunk/java/engine/org/apache/derby/impl/sql/catalog/DataDictionaryImpl.java
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/engine/org/apache/derby/impl/sql/catalog/DataDictionaryImpl.java?view=diff&rev=523028&r1=523027&r2=523028
==============================================================================
--- db/derby/code/trunk/java/engine/org/apache/derby/impl/sql/catalog/DataDictionaryImpl.java (original)
+++ db/derby/code/trunk/java/engine/org/apache/derby/impl/sql/catalog/DataDictionaryImpl.java Tue Mar 27 11:43:14 2007
@@ -10453,7 +10453,7 @@
         throws StandardException
     {
 
-        /* SYSCS_EXPORT_TABLE_LOBS_IN_EXTFILE(IN SCHEMANAME  VARCHAR(128), 
+        /* SYSCS_EXPORT_TABLE_LOBS_TO_EXTFILE(IN SCHEMANAME  VARCHAR(128), 
          * IN TABLENAME    VARCHAR(128), IN FILENAME VARCHAR(32672) , 
          * IN COLUMNDELIMITER CHAR(1),  IN CHARACTERDELIMITER CHAR(1) ,  
          * IN CODESET VARCHAR(128), IN LOBSFILENAME VARCHAR(32672) )
@@ -10485,7 +10485,7 @@
             };
 
             createSystemProcedureOrFunction(
-               "SYSCS_EXPORT_TABLE_LOBS_IN_EXTFILE",
+               "SYSCS_EXPORT_TABLE_LOBS_TO_EXTFILE",
                 sysUtilUUID,
                 arg_names,
                 arg_types,
@@ -10497,11 +10497,11 @@
         }
 
         
-        /* SYSCS_EXPORT_QUERY_LOBS_IN_EXTFILE(
+        /* SYSCS_EXPORT_QUERY_LOBS_TO_EXTFILE(
          * IN SELECTSTATEMENT  VARCHAR(32672), 
          * IN FILENAME VARCHAR(32672) , 
          * IN COLUMNDELIMITER CHAR(1),  IN CHARACTERDELIMITER CHAR(1) ,  
-         * IN CODESET VARCHAR(128))
+         * IN CODESET VARCHAR(128), IN LOBSFILENAME VARCHAR(32672))
          */
         {
             // procedure argument names
@@ -10526,7 +10526,7 @@
             };
 
             createSystemProcedureOrFunction(
-                "SYSCS_EXPORT_QUERY_LOBS_IN_EXTFILE",
+                "SYSCS_EXPORT_QUERY_LOBS_TO_EXTFILE",
                 sysUtilUUID,
                 arg_names,
                 arg_types,
@@ -10538,7 +10538,7 @@
         }
 
         		
-        /*  SYSCS_IMPORT_TABLE_LOBS_IN_EXTFILE(IN SCHEMANAME VARCHAR(128), 
+        /*  SYSCS_IMPORT_TABLE_LOBS_FROM_EXTFILE(IN SCHEMANAME VARCHAR(128), 
          *  IN TABLENAME VARCHAR(128),  IN FILENAME VARCHAR(32762), 
          *  IN COLUMNDELIMITER CHAR(1), IN CHARACTERDELIMITER  CHAR(1),  
          *  IN CODESET VARCHAR(128) , IN  REPLACE SMALLINT)
@@ -10568,7 +10568,7 @@
             };
 
             createSystemProcedureOrFunction(
-               "SYSCS_IMPORT_TABLE_LOBS_IN_EXTFILE",
+               "SYSCS_IMPORT_TABLE_LOBS_FROM_EXTFILE",
                sysUtilUUID,
                arg_names,
                arg_types,
@@ -10579,7 +10579,7 @@
                tc);
         }
 
-        /*  SYSCS_IMPORT_DATA_LOBS_IN_EXTFILE(IN SCHEMANAME VARCHAR(128), 
+        /*  SYSCS_IMPORT_DATA_LOBS_FROM_EXTFILE(IN SCHEMANAME VARCHAR(128), 
          *  IN TABLENAME VARCHAR(128), IN INSERTCOLUMNLIST VARCHAR(32762), 
          *  IN COLUMNINDEXES VARCHAR(32762), IN IN FILENAME VARCHAR(32762), 
          *  IN COLUMNDELIMITER CHAR(1), IN CHARACTERDELIMITER  CHAR(1),  
@@ -10617,7 +10617,7 @@
 
 
             createSystemProcedureOrFunction(
-                "SYSCS_IMPORT_DATA_LOBS_IN_EXTFILE",
+                "SYSCS_IMPORT_DATA_LOBS_FROM_EXTFILE",
                 sysUtilUUID,
                 arg_names,
                 arg_types,

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/ieptests.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/ieptests.out?view=diff&rev=523028&r1=523027&r2=523028
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/ieptests.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/ieptests.out Tue Mar 27 11:43:14 2007
@@ -916,127 +916,5 @@
 ij> drop table inventory.orderTable;
 0 rows inserted/updated/deleted
 ij> --end derby-390 related test cases.
------DERBY-378 , Add support to import/export of lobs
-create table books(id int , name varchar(30) , abstract clob(90), pic blob(100));
-0 rows inserted/updated/deleted
-ij> create table imp_books(id int , name varchar(30),  abstract clob(90), pic blob(100));
-0 rows inserted/updated/deleted
-ij> insert into books values(1, 'effective java' , 
-                        'describes how to write " quality java " code', 
-                         cast (X'124594322143423214ab35f2e34c' as blob));
-1 row inserted/updated/deleted
-ij> insert into books values(2, 'Apache Derby ' , 
-                         'This books covers Apache Derby Database Engine', 
-                         cast (X'134594322143423214ab35f2e44d' as blob));
-1 row inserted/updated/deleted
-ij> insert into books values(3, 'Transaction Processing' , 
-                         'This books covers "Transaction" "processing" concepts', 
-                          cast (X'144594322143423214ab35f2e54e' as blob));
-1 row inserted/updated/deleted
-ij> select * from books;
-ID |NAME |ABSTRACT |PIC                                                                                                                             
------
-1 |effective java |describes how to write " quality java " code |124594322143423214ab35f2e34c                                                                                                    
-2 |Apache Derby |This books covers Apache Derby Database Engine |134594322143423214ab35f2e44d                                                                                                    
-3 |Transaction Processing |This books covers "Transaction" "processing" concepts |144594322143423214ab35f2e54e                                                                                                    
-ij> -- export lobs to an external file.
-call SYSCS_UTIL.SYSCS_EXPORT_TABLE_LOBS_IN_EXTFILE (null, 'BOOKS','extinout/books.dat', 
-                            null, null, null, 'extinout/books_lobs.dat') ;
-Statement executed.
-ij> -- import lobs stored in an external file. 
-call SYSCS_UTIL.SYSCS_IMPORT_TABLE_LOBS_IN_EXTFILE(null, 'IMP_BOOKS' , 
-                                      'extinout/books.dat', null, null, null, 0) ;
-Statement executed.
-ij> select * from imp_books ;
-ID |NAME |ABSTRACT |PIC                                                                                                                             
------
-1 |effective java |describes how to write " quality java " code |124594322143423214ab35f2e34c                                                                                                    
-2 |Apache Derby |This books covers Apache Derby Database Engine |134594322143423214ab35f2e44d                                                                                                    
-3 |Transaction Processing |This books covers "Transaction" "processing" concepts |144594322143423214ab35f2e54e                                                                                                    
-ij> -- import only some columns;
-call SYSCS_UTIL.SYSCS_IMPORT_DATA_LOBS_IN_EXTFILE(null, 
-                                    'IMP_BOOKS' ,'ID, ABSTRACT, PIC', '1,3,4',
-                                    'extinout/books.dat', null, null, null, 1) ;
-Statement executed.
-ij> select * from imp_books;
-ID |NAME |ABSTRACT |PIC                                                                                                                             
------
-1 |NULL |describes how to write " quality java " code |124594322143423214ab35f2e34c                                                                                                    
-2 |NULL |This books covers Apache Derby Database Engine |134594322143423214ab35f2e44d                                                                                                    
-3 |NULL |This books covers "Transaction" "processing" concepts |144594322143423214ab35f2e54e                                                                                                    
-ij> -- import columns in different order, this will test reading lob data 
------ from the file in a random order.
-call SYSCS_UTIL.SYSCS_IMPORT_DATA_LOBS_IN_EXTFILE(null, 
-                                    'IMP_BOOKS' ,'PIC, ID, ABSTRACT, NAME', '4,1,3,2',
-                                    'extinout/books.dat', null, null, null, 1) ;
-Statement executed.
-ij> select * from imp_books;
-ID |NAME |ABSTRACT |PIC                                                                                                                             
------
-1 |effective java |describes how to write " quality java " code |124594322143423214ab35f2e34c                                                                                                    
-2 |Apache Derby |This books covers Apache Derby Database Engine |134594322143423214ab35f2e44d                                                                                                    
-3 |Transaction Processing |This books covers "Transaction" "processing" concepts |144594322143423214ab35f2e54e                                                                                                    
-ij> -- export using a query. 
-call SYSCS_UTIL.SYSCS_EXPORT_QUERY_LOBS_IN_EXTFILE('select * from books where id > 2', 
-             'extinout/books.dat' , null, null, null, 'extinout/books_lobs.dat') ;
-Statement executed.
-ij> delete from imp_books where id > 2;
-1 row inserted/updated/deleted
-ij> call SYSCS_UTIL.SYSCS_IMPORT_TABLE_LOBS_IN_EXTFILE(null, 'IMP_BOOKS' , 
-                                      'extinout/books.dat' ,
-                                      null, null, null, 0) ;
-Statement executed.
-ij> select * from imp_books;
-ID |NAME |ABSTRACT |PIC                                                                                                                             
------
-1 |effective java |describes how to write " quality java " code |124594322143423214ab35f2e34c                                                                                                    
-2 |Apache Derby |This books covers Apache Derby Database Engine |134594322143423214ab35f2e44d                                                                                                    
-3 |Transaction Processing |This books covers "Transaction" "processing" concepts |144594322143423214ab35f2e54e                                                                                                    
-ij> -- export lob data also to given export file. This should write blob 
------ data in  hex format and clob data in double-delimiter to 
------  the export  file. 
-call SYSCS_UTIL.SYSCS_EXPORT_TABLE (null, 'BOOKS','extinout/books.dat', 
-                                          null, null, null) ;
-Statement executed.
-ij> delete from imp_books;
-3 rows inserted/updated/deleted
-ij> call SYSCS_UTIL.SYSCS_IMPORT_TABLE (null, 'IMP_BOOKS' , 'extinout/books.dat' ,
-                                      null, null, null, 0) ;
-Statement executed.
-ij> select * from imp_books;
-ID |NAME |ABSTRACT |PIC                                                                                                                             
------
-1 |effective java |describes how to write " quality java " code |124594322143423214ab35f2e34c                                                                                                    
-2 |Apache Derby |This books covers Apache Derby Database Engine |134594322143423214ab35f2e44d                                                                                                    
-3 |Transaction Processing |This books covers "Transaction" "processing" concepts |144594322143423214ab35f2e54e                                                                                                    
-ij> -- import only some columns;
-call SYSCS_UTIL.SYSCS_IMPORT_DATA(null, 'IMP_BOOKS' ,
-                                     'ID, ABSTRACT, PIC', '1,3,4',
-                                    'extinout/books.dat', null, null, null, 1) ;
-Statement executed.
-ij> select * from imp_books;
-ID |NAME |ABSTRACT |PIC                                                                                                                             
------
-1 |NULL |describes how to write " quality java " code |124594322143423214ab35f2e34c                                                                                                    
-2 |NULL |This books covers Apache Derby Database Engine |134594322143423214ab35f2e44d                                                                                                    
-3 |NULL |This books covers "Transaction" "processing" concepts |144594322143423214ab35f2e54e                                                                                                    
-ij> -- export using a query. 
-call SYSCS_UTIL.SYSCS_EXPORT_QUERY('select * from books where id > 2', 
-                                    'extinout/books.dat' , null, null, null) ;
-Statement executed.
-ij> delete from imp_books where id > 2;
-1 row inserted/updated/deleted
-ij> call SYSCS_UTIL.SYSCS_IMPORT_TABLE(null, 'IMP_BOOKS' , 'extinout/books.dat' ,
-                                  	    null, null, null, 0) ;
-Statement executed.
-ij> select * from imp_books;
-ID |NAME |ABSTRACT |PIC                                                                                                                             
------
-1 |NULL |describes how to write " quality java " code |124594322143423214ab35f2e34c                                                                                                    
-2 |NULL |This books covers Apache Derby Database Engine |134594322143423214ab35f2e44d                                                                                                    
-3 |Transaction Processing |This books covers "Transaction" "processing" concepts |144594322143423214ab35f2e54e                                                                                                    
-ij> --drop table imp_books;
------drop table books;
------END DERBY-378 , Add support to import/export of lobs
 ;
 ij> 

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/jdk16/ieptests.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/jdk16/ieptests.out?view=diff&rev=523028&r1=523027&r2=523028
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/jdk16/ieptests.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/jdk16/ieptests.out Tue Mar 27 11:43:14 2007
@@ -916,127 +916,5 @@
 ij> drop table inventory.orderTable;
 0 rows inserted/updated/deleted
 ij> --end derby-390 related test cases.
------DERBY-378 , Add support to import/export of lobs
-create table books(id int , name varchar(30) , abstract clob(90), pic blob(100));
-0 rows inserted/updated/deleted
-ij> create table imp_books(id int , name varchar(30),  abstract clob(90), pic blob(100));
-0 rows inserted/updated/deleted
-ij> insert into books values(1, 'effective java' , 
-                        'describes how to write " quality java " code', 
-                         cast (X'124594322143423214ab35f2e34c' as blob));
-1 row inserted/updated/deleted
-ij> insert into books values(2, 'Apache Derby ' , 
-                         'This books covers Apache Derby Database Engine', 
-                         cast (X'134594322143423214ab35f2e44d' as blob));
-1 row inserted/updated/deleted
-ij> insert into books values(3, 'Transaction Processing' , 
-                         'This books covers "Transaction" "processing" concepts', 
-                          cast (X'144594322143423214ab35f2e54e' as blob));
-1 row inserted/updated/deleted
-ij> select * from books;
-ID |NAME |ABSTRACT |PIC                                                                                                                             
------
-1 |effective java |describes how to write " quality java " code |124594322143423214ab35f2e34c                                                                                                    
-2 |Apache Derby |This books covers Apache Derby Database Engine |134594322143423214ab35f2e44d                                                                                                    
-3 |Transaction Processing |This books covers "Transaction" "processing" concepts |144594322143423214ab35f2e54e                                                                                                    
-ij> -- export lobs to an external file.
-call SYSCS_UTIL.SYSCS_EXPORT_TABLE_LOBS_IN_EXTFILE (null, 'BOOKS','extinout/books.dat', 
-                            null, null, null, 'extinout/books_lobs.dat') ;
-Statement executed.
-ij> -- import lobs stored in an external file. 
-call SYSCS_UTIL.SYSCS_IMPORT_TABLE_LOBS_IN_EXTFILE(null, 'IMP_BOOKS' , 
-                                      'extinout/books.dat', null, null, null, 0) ;
-Statement executed.
-ij> select * from imp_books ;
-ID |NAME |ABSTRACT |PIC                                                                                                                             
------
-1 |effective java |describes how to write " quality java " code |124594322143423214ab35f2e34c                                                                                                    
-2 |Apache Derby |This books covers Apache Derby Database Engine |134594322143423214ab35f2e44d                                                                                                    
-3 |Transaction Processing |This books covers "Transaction" "processing" concepts |144594322143423214ab35f2e54e                                                                                                    
-ij> -- import only some columns;
-call SYSCS_UTIL.SYSCS_IMPORT_DATA_LOBS_IN_EXTFILE(null, 
-                                    'IMP_BOOKS' ,'ID, ABSTRACT, PIC', '1,3,4',
-                                    'extinout/books.dat', null, null, null, 1) ;
-Statement executed.
-ij> select * from imp_books;
-ID |NAME |ABSTRACT |PIC                                                                                                                             
------
-1 |NULL |describes how to write " quality java " code |124594322143423214ab35f2e34c                                                                                                    
-2 |NULL |This books covers Apache Derby Database Engine |134594322143423214ab35f2e44d                                                                                                    
-3 |NULL |This books covers "Transaction" "processing" concepts |144594322143423214ab35f2e54e                                                                                                    
-ij> -- import columns in different order, this will test reading lob data 
------ from the file in a random order.
-call SYSCS_UTIL.SYSCS_IMPORT_DATA_LOBS_IN_EXTFILE(null, 
-                                    'IMP_BOOKS' ,'PIC, ID, ABSTRACT, NAME', '4,1,3,2',
-                                    'extinout/books.dat', null, null, null, 1) ;
-Statement executed.
-ij> select * from imp_books;
-ID |NAME |ABSTRACT |PIC                                                                                                                             
------
-1 |effective java |describes how to write " quality java " code |124594322143423214ab35f2e34c                                                                                                    
-2 |Apache Derby |This books covers Apache Derby Database Engine |134594322143423214ab35f2e44d                                                                                                    
-3 |Transaction Processing |This books covers "Transaction" "processing" concepts |144594322143423214ab35f2e54e                                                                                                    
-ij> -- export using a query. 
-call SYSCS_UTIL.SYSCS_EXPORT_QUERY_LOBS_IN_EXTFILE('select * from books where id > 2', 
-             'extinout/books.dat' , null, null, null, 'extinout/books_lobs.dat') ;
-Statement executed.
-ij> delete from imp_books where id > 2;
-1 row inserted/updated/deleted
-ij> call SYSCS_UTIL.SYSCS_IMPORT_TABLE_LOBS_IN_EXTFILE(null, 'IMP_BOOKS' , 
-                                      'extinout/books.dat' ,
-                                      null, null, null, 0) ;
-Statement executed.
-ij> select * from imp_books;
-ID |NAME |ABSTRACT |PIC                                                                                                                             
------
-1 |effective java |describes how to write " quality java " code |124594322143423214ab35f2e34c                                                                                                    
-2 |Apache Derby |This books covers Apache Derby Database Engine |134594322143423214ab35f2e44d                                                                                                    
-3 |Transaction Processing |This books covers "Transaction" "processing" concepts |144594322143423214ab35f2e54e                                                                                                    
-ij> -- export lob data also to given export file. This should write blob 
------ data in  hex format and clob data in double-delimiter to 
------  the export  file. 
-call SYSCS_UTIL.SYSCS_EXPORT_TABLE (null, 'BOOKS','extinout/books.dat', 
-                                          null, null, null) ;
-Statement executed.
-ij> delete from imp_books;
-3 rows inserted/updated/deleted
-ij> call SYSCS_UTIL.SYSCS_IMPORT_TABLE (null, 'IMP_BOOKS' , 'extinout/books.dat' ,
-                                      null, null, null, 0) ;
-Statement executed.
-ij> select * from imp_books;
-ID |NAME |ABSTRACT |PIC                                                                                                                             
------
-1 |effective java |describes how to write " quality java " code |124594322143423214ab35f2e34c                                                                                                    
-2 |Apache Derby |This books covers Apache Derby Database Engine |134594322143423214ab35f2e44d                                                                                                    
-3 |Transaction Processing |This books covers "Transaction" "processing" concepts |144594322143423214ab35f2e54e                                                                                                    
-ij> -- import only some columns;
-call SYSCS_UTIL.SYSCS_IMPORT_DATA(null, 'IMP_BOOKS' ,
-                                     'ID, ABSTRACT, PIC', '1,3,4',
-                                    'extinout/books.dat', null, null, null, 1) ;
-Statement executed.
-ij> select * from imp_books;
-ID |NAME |ABSTRACT |PIC                                                                                                                             
------
-1 |NULL |describes how to write " quality java " code |124594322143423214ab35f2e34c                                                                                                    
-2 |NULL |This books covers Apache Derby Database Engine |134594322143423214ab35f2e44d                                                                                                    
-3 |NULL |This books covers "Transaction" "processing" concepts |144594322143423214ab35f2e54e                                                                                                    
-ij> -- export using a query. 
-call SYSCS_UTIL.SYSCS_EXPORT_QUERY('select * from books where id > 2', 
-                                    'extinout/books.dat' , null, null, null) ;
-Statement executed.
-ij> delete from imp_books where id > 2;
-1 row inserted/updated/deleted
-ij> call SYSCS_UTIL.SYSCS_IMPORT_TABLE(null, 'IMP_BOOKS' , 'extinout/books.dat' ,
-                                  	    null, null, null, 0) ;
-Statement executed.
-ij> select * from imp_books;
-ID |NAME |ABSTRACT |PIC                                                                                                                             
------
-1 |NULL |describes how to write " quality java " code |124594322143423214ab35f2e34c                                                                                                    
-2 |NULL |This books covers Apache Derby Database Engine |134594322143423214ab35f2e44d                                                                                                    
-3 |Transaction Processing |This books covers "Transaction" "processing" concepts |144594322143423214ab35f2e54e                                                                                                    
-ij> --drop table imp_books;
------drop table books;
------END DERBY-378 , Add support to import/export of lobs
 ;
 ij> 

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/ieptests.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/ieptests.out?view=diff&rev=523028&r1=523027&r2=523028
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/ieptests.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/ieptests.out Tue Mar 27 11:43:14 2007
@@ -916,127 +916,5 @@
 ij> drop table inventory.orderTable;
 0 rows inserted/updated/deleted
 ij> --end derby-390 related test cases.
------DERBY-378 , Add support to import/export of lobs
-create table books(id int , name varchar(30) , abstract clob(90), pic blob(100));
-0 rows inserted/updated/deleted
-ij> create table imp_books(id int , name varchar(30),  abstract clob(90), pic blob(100));
-0 rows inserted/updated/deleted
-ij> insert into books values(1, 'effective java' , 
-                        'describes how to write " quality java " code', 
-                         cast (X'124594322143423214ab35f2e34c' as blob));
-1 row inserted/updated/deleted
-ij> insert into books values(2, 'Apache Derby ' , 
-                         'This books covers Apache Derby Database Engine', 
-                         cast (X'134594322143423214ab35f2e44d' as blob));
-1 row inserted/updated/deleted
-ij> insert into books values(3, 'Transaction Processing' , 
-                         'This books covers "Transaction" "processing" concepts', 
-                          cast (X'144594322143423214ab35f2e54e' as blob));
-1 row inserted/updated/deleted
-ij> select * from books;
-ID |NAME |ABSTRACT |PIC                                                                                                                             
------
-1 |effective java |describes how to write " quality java " code |124594322143423214ab35f2e34c                                                                                                    
-2 |Apache Derby |This books covers Apache Derby Database Engine |134594322143423214ab35f2e44d                                                                                                    
-3 |Transaction Processing |This books covers "Transaction" "processing" concepts |144594322143423214ab35f2e54e                                                                                                    
-ij> -- export lobs to an external file.
-call SYSCS_UTIL.SYSCS_EXPORT_TABLE_LOBS_IN_EXTFILE (null, 'BOOKS','extinout/books.dat', 
-                            null, null, null, 'extinout/books_lobs.dat') ;
-Statement executed.
-ij> -- import lobs stored in an external file. 
-call SYSCS_UTIL.SYSCS_IMPORT_TABLE_LOBS_IN_EXTFILE(null, 'IMP_BOOKS' , 
-                                      'extinout/books.dat', null, null, null, 0) ;
-Statement executed.
-ij> select * from imp_books ;
-ID |NAME |ABSTRACT |PIC                                                                                                                             
------
-1 |effective java |describes how to write " quality java " code |124594322143423214ab35f2e34c                                                                                                    
-2 |Apache Derby |This books covers Apache Derby Database Engine |134594322143423214ab35f2e44d                                                                                                    
-3 |Transaction Processing |This books covers "Transaction" "processing" concepts |144594322143423214ab35f2e54e                                                                                                    
-ij> -- import only some columns;
-call SYSCS_UTIL.SYSCS_IMPORT_DATA_LOBS_IN_EXTFILE(null, 
-                                    'IMP_BOOKS' ,'ID, ABSTRACT, PIC', '1,3,4',
-                                    'extinout/books.dat', null, null, null, 1) ;
-Statement executed.
-ij> select * from imp_books;
-ID |NAME |ABSTRACT |PIC                                                                                                                             
------
-1 |NULL |describes how to write " quality java " code |124594322143423214ab35f2e34c                                                                                                    
-2 |NULL |This books covers Apache Derby Database Engine |134594322143423214ab35f2e44d                                                                                                    
-3 |NULL |This books covers "Transaction" "processing" concepts |144594322143423214ab35f2e54e                                                                                                    
-ij> -- import columns in different order, this will test reading lob data 
------ from the file in a random order.
-call SYSCS_UTIL.SYSCS_IMPORT_DATA_LOBS_IN_EXTFILE(null, 
-                                    'IMP_BOOKS' ,'PIC, ID, ABSTRACT, NAME', '4,1,3,2',
-                                    'extinout/books.dat', null, null, null, 1) ;
-Statement executed.
-ij> select * from imp_books;
-ID |NAME |ABSTRACT |PIC                                                                                                                             
------
-1 |effective java |describes how to write " quality java " code |124594322143423214ab35f2e34c                                                                                                    
-2 |Apache Derby |This books covers Apache Derby Database Engine |134594322143423214ab35f2e44d                                                                                                    
-3 |Transaction Processing |This books covers "Transaction" "processing" concepts |144594322143423214ab35f2e54e                                                                                                    
-ij> -- export using a query. 
-call SYSCS_UTIL.SYSCS_EXPORT_QUERY_LOBS_IN_EXTFILE('select * from books where id > 2', 
-             'extinout/books.dat' , null, null, null, 'extinout/books_lobs.dat') ;
-Statement executed.
-ij> delete from imp_books where id > 2;
-1 row inserted/updated/deleted
-ij> call SYSCS_UTIL.SYSCS_IMPORT_TABLE_LOBS_IN_EXTFILE(null, 'IMP_BOOKS' , 
-                                      'extinout/books.dat' ,
-                                      null, null, null, 0) ;
-Statement executed.
-ij> select * from imp_books;
-ID |NAME |ABSTRACT |PIC                                                                                                                             
------
-1 |effective java |describes how to write " quality java " code |124594322143423214ab35f2e34c                                                                                                    
-2 |Apache Derby |This books covers Apache Derby Database Engine |134594322143423214ab35f2e44d                                                                                                    
-3 |Transaction Processing |This books covers "Transaction" "processing" concepts |144594322143423214ab35f2e54e                                                                                                    
-ij> -- export lob data also to given export file. This should write blob 
------ data in  hex format and clob data in double-delimiter to 
------  the export  file. 
-call SYSCS_UTIL.SYSCS_EXPORT_TABLE (null, 'BOOKS','extinout/books.dat', 
-                                          null, null, null) ;
-Statement executed.
-ij> delete from imp_books;
-3 rows inserted/updated/deleted
-ij> call SYSCS_UTIL.SYSCS_IMPORT_TABLE (null, 'IMP_BOOKS' , 'extinout/books.dat' ,
-                                      null, null, null, 0) ;
-Statement executed.
-ij> select * from imp_books;
-ID |NAME |ABSTRACT |PIC                                                                                                                             
------
-1 |effective java |describes how to write " quality java " code |124594322143423214ab35f2e34c                                                                                                    
-2 |Apache Derby |This books covers Apache Derby Database Engine |134594322143423214ab35f2e44d                                                                                                    
-3 |Transaction Processing |This books covers "Transaction" "processing" concepts |144594322143423214ab35f2e54e                                                                                                    
-ij> -- import only some columns;
-call SYSCS_UTIL.SYSCS_IMPORT_DATA(null, 'IMP_BOOKS' ,
-                                     'ID, ABSTRACT, PIC', '1,3,4',
-                                    'extinout/books.dat', null, null, null, 1) ;
-Statement executed.
-ij> select * from imp_books;
-ID |NAME |ABSTRACT |PIC                                                                                                                             
------
-1 |NULL |describes how to write " quality java " code |124594322143423214ab35f2e34c                                                                                                    
-2 |NULL |This books covers Apache Derby Database Engine |134594322143423214ab35f2e44d                                                                                                    
-3 |NULL |This books covers "Transaction" "processing" concepts |144594322143423214ab35f2e54e                                                                                                    
-ij> -- export using a query. 
-call SYSCS_UTIL.SYSCS_EXPORT_QUERY('select * from books where id > 2', 
-                                    'extinout/books.dat' , null, null, null) ;
-Statement executed.
-ij> delete from imp_books where id > 2;
-1 row inserted/updated/deleted
-ij> call SYSCS_UTIL.SYSCS_IMPORT_TABLE(null, 'IMP_BOOKS' , 'extinout/books.dat' ,
-                                  	    null, null, null, 0) ;
-Statement executed.
-ij> select * from imp_books;
-ID |NAME |ABSTRACT |PIC                                                                                                                             
------
-1 |NULL |describes how to write " quality java " code |124594322143423214ab35f2e34c                                                                                                    
-2 |NULL |This books covers Apache Derby Database Engine |134594322143423214ab35f2e44d                                                                                                    
-3 |Transaction Processing |This books covers "Transaction" "processing" concepts |144594322143423214ab35f2e54e                                                                                                    
-ij> --drop table imp_books;
------drop table books;
------END DERBY-378 , Add support to import/export of lobs
 ;
 ij> 

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/jdk16/ieptests.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/jdk16/ieptests.out?view=diff&rev=523028&r1=523027&r2=523028
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/jdk16/ieptests.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/jdk16/ieptests.out Tue Mar 27 11:43:14 2007
@@ -916,127 +916,5 @@
 ij> drop table inventory.orderTable;
 0 rows inserted/updated/deleted
 ij> --end derby-390 related test cases.
------DERBY-378 , Add support to import/export of lobs
-create table books(id int , name varchar(30) , abstract clob(90), pic blob(100));
-0 rows inserted/updated/deleted
-ij> create table imp_books(id int , name varchar(30),  abstract clob(90), pic blob(100));
-0 rows inserted/updated/deleted
-ij> insert into books values(1, 'effective java' , 
-                        'describes how to write " quality java " code', 
-                         cast (X'124594322143423214ab35f2e34c' as blob));
-1 row inserted/updated/deleted
-ij> insert into books values(2, 'Apache Derby ' , 
-                         'This books covers Apache Derby Database Engine', 
-                         cast (X'134594322143423214ab35f2e44d' as blob));
-1 row inserted/updated/deleted
-ij> insert into books values(3, 'Transaction Processing' , 
-                         'This books covers "Transaction" "processing" concepts', 
-                          cast (X'144594322143423214ab35f2e54e' as blob));
-1 row inserted/updated/deleted
-ij> select * from books;
-ID |NAME |ABSTRACT |PIC                                                                                                                             
------
-1 |effective java |describes how to write " quality java " code |124594322143423214ab35f2e34c                                                                                                    
-2 |Apache Derby |This books covers Apache Derby Database Engine |134594322143423214ab35f2e44d                                                                                                    
-3 |Transaction Processing |This books covers "Transaction" "processing" concepts |144594322143423214ab35f2e54e                                                                                                    
-ij> -- export lobs to an external file.
-call SYSCS_UTIL.SYSCS_EXPORT_TABLE_LOBS_IN_EXTFILE (null, 'BOOKS','extinout/books.dat', 
-                            null, null, null, 'extinout/books_lobs.dat') ;
-Statement executed.
-ij> -- import lobs stored in an external file. 
-call SYSCS_UTIL.SYSCS_IMPORT_TABLE_LOBS_IN_EXTFILE(null, 'IMP_BOOKS' , 
-                                      'extinout/books.dat', null, null, null, 0) ;
-Statement executed.
-ij> select * from imp_books ;
-ID |NAME |ABSTRACT |PIC                                                                                                                             
------
-1 |effective java |describes how to write " quality java " code |124594322143423214ab35f2e34c                                                                                                    
-2 |Apache Derby |This books covers Apache Derby Database Engine |134594322143423214ab35f2e44d                                                                                                    
-3 |Transaction Processing |This books covers "Transaction" "processing" concepts |144594322143423214ab35f2e54e                                                                                                    
-ij> -- import only some columns;
-call SYSCS_UTIL.SYSCS_IMPORT_DATA_LOBS_IN_EXTFILE(null, 
-                                    'IMP_BOOKS' ,'ID, ABSTRACT, PIC', '1,3,4',
-                                    'extinout/books.dat', null, null, null, 1) ;
-Statement executed.
-ij> select * from imp_books;
-ID |NAME |ABSTRACT |PIC                                                                                                                             
------
-1 |NULL |describes how to write " quality java " code |124594322143423214ab35f2e34c                                                                                                    
-2 |NULL |This books covers Apache Derby Database Engine |134594322143423214ab35f2e44d                                                                                                    
-3 |NULL |This books covers "Transaction" "processing" concepts |144594322143423214ab35f2e54e                                                                                                    
-ij> -- import columns in different order, this will test reading lob data 
------ from the file in a random order.
-call SYSCS_UTIL.SYSCS_IMPORT_DATA_LOBS_IN_EXTFILE(null, 
-                                    'IMP_BOOKS' ,'PIC, ID, ABSTRACT, NAME', '4,1,3,2',
-                                    'extinout/books.dat', null, null, null, 1) ;
-Statement executed.
-ij> select * from imp_books;
-ID |NAME |ABSTRACT |PIC                                                                                                                             
------
-1 |effective java |describes how to write " quality java " code |124594322143423214ab35f2e34c                                                                                                    
-2 |Apache Derby |This books covers Apache Derby Database Engine |134594322143423214ab35f2e44d                                                                                                    
-3 |Transaction Processing |This books covers "Transaction" "processing" concepts |144594322143423214ab35f2e54e                                                                                                    
-ij> -- export using a query. 
-call SYSCS_UTIL.SYSCS_EXPORT_QUERY_LOBS_IN_EXTFILE('select * from books where id > 2', 
-             'extinout/books.dat' , null, null, null, 'extinout/books_lobs.dat') ;
-Statement executed.
-ij> delete from imp_books where id > 2;
-1 row inserted/updated/deleted
-ij> call SYSCS_UTIL.SYSCS_IMPORT_TABLE_LOBS_IN_EXTFILE(null, 'IMP_BOOKS' , 
-                                      'extinout/books.dat' ,
-                                      null, null, null, 0) ;
-Statement executed.
-ij> select * from imp_books;
-ID |NAME |ABSTRACT |PIC                                                                                                                             
------
-1 |effective java |describes how to write " quality java " code |124594322143423214ab35f2e34c                                                                                                    
-2 |Apache Derby |This books covers Apache Derby Database Engine |134594322143423214ab35f2e44d                                                                                                    
-3 |Transaction Processing |This books covers "Transaction" "processing" concepts |144594322143423214ab35f2e54e                                                                                                    
-ij> -- export lob data also to given export file. This should write blob 
------ data in  hex format and clob data in double-delimiter to 
------  the export  file. 
-call SYSCS_UTIL.SYSCS_EXPORT_TABLE (null, 'BOOKS','extinout/books.dat', 
-                                          null, null, null) ;
-Statement executed.
-ij> delete from imp_books;
-3 rows inserted/updated/deleted
-ij> call SYSCS_UTIL.SYSCS_IMPORT_TABLE (null, 'IMP_BOOKS' , 'extinout/books.dat' ,
-                                      null, null, null, 0) ;
-Statement executed.
-ij> select * from imp_books;
-ID |NAME |ABSTRACT |PIC                                                                                                                             
------
-1 |effective java |describes how to write " quality java " code |124594322143423214ab35f2e34c                                                                                                    
-2 |Apache Derby |This books covers Apache Derby Database Engine |134594322143423214ab35f2e44d                                                                                                    
-3 |Transaction Processing |This books covers "Transaction" "processing" concepts |144594322143423214ab35f2e54e                                                                                                    
-ij> -- import only some columns;
-call SYSCS_UTIL.SYSCS_IMPORT_DATA(null, 'IMP_BOOKS' ,
-                                     'ID, ABSTRACT, PIC', '1,3,4',
-                                    'extinout/books.dat', null, null, null, 1) ;
-Statement executed.
-ij> select * from imp_books;
-ID |NAME |ABSTRACT |PIC                                                                                                                             
------
-1 |NULL |describes how to write " quality java " code |124594322143423214ab35f2e34c                                                                                                    
-2 |NULL |This books covers Apache Derby Database Engine |134594322143423214ab35f2e44d                                                                                                    
-3 |NULL |This books covers "Transaction" "processing" concepts |144594322143423214ab35f2e54e                                                                                                    
-ij> -- export using a query. 
-call SYSCS_UTIL.SYSCS_EXPORT_QUERY('select * from books where id > 2', 
-                                    'extinout/books.dat' , null, null, null) ;
-Statement executed.
-ij> delete from imp_books where id > 2;
-1 row inserted/updated/deleted
-ij> call SYSCS_UTIL.SYSCS_IMPORT_TABLE(null, 'IMP_BOOKS' , 'extinout/books.dat' ,
-                                  	    null, null, null, 0) ;
-Statement executed.
-ij> select * from imp_books;
-ID |NAME |ABSTRACT |PIC                                                                                                                             
------
-1 |NULL |describes how to write " quality java " code |124594322143423214ab35f2e34c                                                                                                    
-2 |NULL |This books covers Apache Derby Database Engine |134594322143423214ab35f2e44d                                                                                                    
-3 |Transaction Processing |This books covers "Transaction" "processing" concepts |144594322143423214ab35f2e54e                                                                                                    
-ij> --drop table imp_books;
------drop table books;
------END DERBY-378 , Add support to import/export of lobs
 ;
 ij> 

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/ieptests.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/ieptests.out?view=diff&rev=523028&r1=523027&r2=523028
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/ieptests.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/ieptests.out Tue Mar 27 11:43:14 2007
@@ -939,127 +939,5 @@
 ij> drop table inventory.orderTable;
 0 rows inserted/updated/deleted
 ij> --end derby-390 related test cases.
----DERBY-378 , Add support to import/export of lobs
-create table books(id int , name varchar(30) , abstract clob(90), pic blob(100));
-0 rows inserted/updated/deleted
-ij> create table imp_books(id int , name varchar(30),  abstract clob(90), pic blob(100));
-0 rows inserted/updated/deleted
-ij> insert into books values(1, 'effective java' , 
-                        'describes how to write " quality java " code', 
-                         cast (X'124594322143423214ab35f2e34c' as blob));
-1 row inserted/updated/deleted
-ij> insert into books values(2, 'Apache Derby ' , 
-                         'This books covers Apache Derby Database Engine', 
-                         cast (X'134594322143423214ab35f2e44d' as blob));
-1 row inserted/updated/deleted
-ij> insert into books values(3, 'Transaction Processing' , 
-                         'This books covers "Transaction" "processing" concepts', 
-                          cast (X'144594322143423214ab35f2e54e' as blob));
-1 row inserted/updated/deleted
-ij> select * from books;
-ID         |NAME                          |ABSTRACT                                                                                  |PIC                                                                                                                             
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-1          |effective java                |describes how to write " quality java " code                                              |124594322143423214ab35f2e34c                                                                                                    
-2          |Apache Derby                  |This books covers Apache Derby Database Engine                                            |134594322143423214ab35f2e44d                                                                                                    
-3          |Transaction Processing        |This books covers "Transaction" "processing" concepts                                     |144594322143423214ab35f2e54e                                                                                                    
-ij> -- export lobs to an external file.
-call SYSCS_UTIL.SYSCS_EXPORT_TABLE_LOBS_IN_EXTFILE (null, 'BOOKS','extinout/books.dat', 
-                            null, null, null, 'extinout/books_lobs.dat') ;
-0 rows inserted/updated/deleted
-ij> -- import lobs stored in an external file. 
-call SYSCS_UTIL.SYSCS_IMPORT_TABLE_LOBS_IN_EXTFILE(null, 'IMP_BOOKS' , 
-                                      'extinout/books.dat', null, null, null, 0) ;
-0 rows inserted/updated/deleted
-ij> select * from imp_books ;
-ID         |NAME                          |ABSTRACT                                                                                  |PIC                                                                                                                             
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-1          |effective java                |describes how to write " quality java " code                                              |124594322143423214ab35f2e34c                                                                                                    
-2          |Apache Derby                  |This books covers Apache Derby Database Engine                                            |134594322143423214ab35f2e44d                                                                                                    
-3          |Transaction Processing        |This books covers "Transaction" "processing" concepts                                     |144594322143423214ab35f2e54e                                                                                                    
-ij> -- import only some columns;
-call SYSCS_UTIL.SYSCS_IMPORT_DATA_LOBS_IN_EXTFILE(null, 
-                                    'IMP_BOOKS' ,'ID, ABSTRACT, PIC', '1,3,4',
-                                    'extinout/books.dat', null, null, null, 1) ;
-0 rows inserted/updated/deleted
-ij> select * from imp_books;
-ID         |NAME                          |ABSTRACT                                                                                  |PIC                                                                                                                             
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-1          |NULL                          |describes how to write " quality java " code                                              |124594322143423214ab35f2e34c                                                                                                    
-2          |NULL                          |This books covers Apache Derby Database Engine                                            |134594322143423214ab35f2e44d                                                                                                    
-3          |NULL                          |This books covers "Transaction" "processing" concepts                                     |144594322143423214ab35f2e54e                                                                                                    
-ij> -- import columns in different order, this will test reading lob data 
--- from the file in a random order.
-call SYSCS_UTIL.SYSCS_IMPORT_DATA_LOBS_IN_EXTFILE(null, 
-                                    'IMP_BOOKS' ,'PIC, ID, ABSTRACT, NAME', '4,1,3,2',
-                                    'extinout/books.dat', null, null, null, 1) ;
-0 rows inserted/updated/deleted
-ij> select * from imp_books;
-ID         |NAME                          |ABSTRACT                                                                                  |PIC                                                                                                                             
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-1          |effective java                |describes how to write " quality java " code                                              |124594322143423214ab35f2e34c                                                                                                    
-2          |Apache Derby                  |This books covers Apache Derby Database Engine                                            |134594322143423214ab35f2e44d                                                                                                    
-3          |Transaction Processing        |This books covers "Transaction" "processing" concepts                                     |144594322143423214ab35f2e54e                                                                                                    
-ij> -- export using a query. 
-call SYSCS_UTIL.SYSCS_EXPORT_QUERY_LOBS_IN_EXTFILE('select * from books where id > 2', 
-             'extinout/books.dat' , null, null, null, 'extinout/books_lobs.dat') ;
-0 rows inserted/updated/deleted
-ij> delete from imp_books where id > 2;
-1 row inserted/updated/deleted
-ij> call SYSCS_UTIL.SYSCS_IMPORT_TABLE_LOBS_IN_EXTFILE(null, 'IMP_BOOKS' , 
-                                      'extinout/books.dat' ,
-                                      null, null, null, 0) ;
-0 rows inserted/updated/deleted
-ij> select * from imp_books;
-ID         |NAME                          |ABSTRACT                                                                                  |PIC                                                                                                                             
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-1          |effective java                |describes how to write " quality java " code                                              |124594322143423214ab35f2e34c                                                                                                    
-2          |Apache Derby                  |This books covers Apache Derby Database Engine                                            |134594322143423214ab35f2e44d                                                                                                    
-3          |Transaction Processing        |This books covers "Transaction" "processing" concepts                                     |144594322143423214ab35f2e54e                                                                                                    
-ij> -- export lob data also to given export file. This should write blob 
--- data in  hex format and clob data in double-delimiter to 
---  the export  file. 
-call SYSCS_UTIL.SYSCS_EXPORT_TABLE (null, 'BOOKS','extinout/books.dat', 
-                                          null, null, null) ;
-0 rows inserted/updated/deleted
-ij> delete from imp_books;
-3 rows inserted/updated/deleted
-ij> call SYSCS_UTIL.SYSCS_IMPORT_TABLE (null, 'IMP_BOOKS' , 'extinout/books.dat' ,
-                                      null, null, null, 0) ;
-0 rows inserted/updated/deleted
-ij> select * from imp_books;
-ID         |NAME                          |ABSTRACT                                                                                  |PIC                                                                                                                             
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-1          |effective java                |describes how to write " quality java " code                                              |124594322143423214ab35f2e34c                                                                                                    
-2          |Apache Derby                  |This books covers Apache Derby Database Engine                                            |134594322143423214ab35f2e44d                                                                                                    
-3          |Transaction Processing        |This books covers "Transaction" "processing" concepts                                     |144594322143423214ab35f2e54e                                                                                                    
-ij> -- import only some columns;
-call SYSCS_UTIL.SYSCS_IMPORT_DATA(null, 'IMP_BOOKS' ,
-                                     'ID, ABSTRACT, PIC', '1,3,4',
-                                    'extinout/books.dat', null, null, null, 1) ;
-0 rows inserted/updated/deleted
-ij> select * from imp_books;
-ID         |NAME                          |ABSTRACT                                                                                  |PIC                                                                                                                             
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-1          |NULL                          |describes how to write " quality java " code                                              |124594322143423214ab35f2e34c                                                                                                    
-2          |NULL                          |This books covers Apache Derby Database Engine                                            |134594322143423214ab35f2e44d                                                                                                    
-3          |NULL                          |This books covers "Transaction" "processing" concepts                                     |144594322143423214ab35f2e54e                                                                                                    
-ij> -- export using a query. 
-call SYSCS_UTIL.SYSCS_EXPORT_QUERY('select * from books where id > 2', 
-                                    'extinout/books.dat' , null, null, null) ;
-0 rows inserted/updated/deleted
-ij> delete from imp_books where id > 2;
-1 row inserted/updated/deleted
-ij> call SYSCS_UTIL.SYSCS_IMPORT_TABLE(null, 'IMP_BOOKS' , 'extinout/books.dat' ,
-                                  	    null, null, null, 0) ;
-0 rows inserted/updated/deleted
-ij> select * from imp_books;
-ID         |NAME                          |ABSTRACT                                                                                  |PIC                                                                                                                             
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-1          |NULL                          |describes how to write " quality java " code                                              |124594322143423214ab35f2e34c                                                                                                    
-2          |NULL                          |This books covers Apache Derby Database Engine                                            |134594322143423214ab35f2e44d                                                                                                    
-3          |Transaction Processing        |This books covers "Transaction" "processing" concepts                                     |144594322143423214ab35f2e54e                                                                                                    
-ij> --drop table imp_books;
---drop table books;
----END DERBY-378 , Add support to import/export of lobs
 ;
 ij> 

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/tools/ImportExportBaseTest.java
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/tools/ImportExportBaseTest.java?view=diff&rev=523028&r1=523027&r2=523028
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/tools/ImportExportBaseTest.java (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/tools/ImportExportBaseTest.java Tue Mar 27 11:43:14 2007
@@ -144,9 +144,9 @@
 
     /**
      * Perform export using 
-     * SYSCS_UTIL.SYSCS_EXPORT_TABLE_LOBS_IN_EXTFILE procedure.
+     * SYSCS_UTIL.SYSCS_EXPORT_TABLE_LOBS_TO_EXTFILE procedure.
      */
-    protected void doExportTableLobsInExtFile(String schemaName, 
+    protected void doExportTableLobsToExtFile(String schemaName, 
                                               String tableName, 
                                               String fileName, 
                                               String colDel , 
@@ -156,7 +156,7 @@
         throws SQLException 
     {
         String expsql = 
-            "call SYSCS_UTIL.SYSCS_EXPORT_TABLE_LOBS_IN_EXTFILE" +  
+            "call SYSCS_UTIL.SYSCS_EXPORT_TABLE_LOBS_TO_EXTFILE" +  
             "(? , ? , ? , ?, ?, ?, ?)";
         PreparedStatement ps = prepareStatement(expsql);
         ps.setString(1, schemaName);
@@ -174,9 +174,9 @@
 
     /**
      * Perform export using 
-     * SYSCS_UTIL.SYSCS_EXPORT_QUERY_LOBS_IN_EXTFILE procedure.
+     * SYSCS_UTIL.SYSCS_EXPORT_QUERY_LOBS_TO_EXTFILE procedure.
      */
-    protected void doExportQueryLobsInExtFile(String query,
+    protected void doExportQueryLobsToExtFile(String query,
                                               String fileName,
                                               String colDel , 
                                               String charDel, 
@@ -185,7 +185,7 @@
         throws SQLException 
     {
         String expsql = 
-            "call SYSCS_UTIL.SYSCS_EXPORT_QUERY_LOBS_IN_EXTFILE" + 
+            "call SYSCS_UTIL.SYSCS_EXPORT_QUERY_LOBS_TO_EXTFILE" + 
             "(? , ? , ? , ?, ?, ?)";
         PreparedStatement ps = prepareStatement(expsql);
         ps.setString(1, query);
@@ -200,9 +200,9 @@
 
     /**
      * Perform import using 
-     * SYSCS_UTIL.SYSCS_IMPORT_TABLE_LOBS_IN_EXTFILE procedure.
+     * SYSCS_UTIL.SYSCS_IMPORT_TABLE_LOBS_FROM_EXTFILE procedure.
      */
-    protected void doImportTableLobsInExtFile(String schemaName,
+    protected void doImportTableLobsFromExtFile(String schemaName,
                                               String tableName, 
                                               String fileName, 
                                               String colDel, 
@@ -212,7 +212,7 @@
         throws SQLException 
     {
         String impsql = 
-            "call SYSCS_UTIL.SYSCS_IMPORT_TABLE_LOBS_IN_EXTFILE" +
+            "call SYSCS_UTIL.SYSCS_IMPORT_TABLE_LOBS_FROM_EXTFILE" +
             "(?, ?, ?, ?, ?, ?, ?)";
         PreparedStatement ps = prepareStatement(impsql);
         ps.setString(1 , schemaName);
@@ -229,21 +229,21 @@
 
     /**
      *  Perform import using 
-     *  SYSCS_UTIL.SYSCS_IMPORT_DATA_LOBS_IN_EXTFILE procedure.
+     *  SYSCS_UTIL.SYSCS_IMPORT_DATA_LOBS_FROM_EXTFILE procedure.
      */
-    protected void doImportDataLobsInExtFile(String schemaName,
-                                              String tableName, 
-                                              String insertCols,
-                                              String colIndexes, 
-                                              String fileName,
-                                              String colDel, 
-                                              String charDel , 
-                                              String codeset, 
-                                              int replace) 
+    protected void doImportDataLobsFromExtFile(String schemaName,
+                                               String tableName, 
+                                               String insertCols,
+                                               String colIndexes, 
+                                               String fileName,
+                                               String colDel, 
+                                               String charDel , 
+                                               String codeset, 
+                                               int replace) 
         throws SQLException 
     {
         String impsql = 
-            "call SYSCS_UTIL.SYSCS_IMPORT_DATA_LOBS_IN_EXTFILE" + 
+            "call SYSCS_UTIL.SYSCS_IMPORT_DATA_LOBS_FROM_EXTFILE" + 
             "(?, ?, ?, ?, ?, ?, ?, ?, ?)";
         PreparedStatement ps = prepareStatement(impsql);
         ps.setString(1, schemaName);

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/tools/ImportExportLobTest.java
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/tools/ImportExportLobTest.java?view=diff&rev=523028&r1=523027&r2=523028
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/tools/ImportExportLobTest.java (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/tools/ImportExportLobTest.java Tue Mar 27 11:43:14 2007
@@ -254,42 +254,43 @@
 
     /**
      * Test import/export of a table, using 
-     * SYSCS_EXPORT_TABLE_LOBS_IN_EXTFILE and 
-     * SYSCS_IMPORT_TABLE_LOBS_IN_EXTFILE  procedures.
+     * SYSCS_EXPORT_TABLE_LOBS_TO_EXTFILE and 
+     * SYSCS_IMPORT_TABLE_LOBS_FROM_EXTFILE  procedures.
      */
     public void testImportTableExportTableLobsInExtFile()  
         throws SQLException, IOException
     {
-        doExportTableLobsInExtFile("APP", "BOOKS", fileName, 
+        doExportTableLobsToExtFile("APP", "BOOKS", fileName, 
                                    null, null , null, lobsFileName);
-	    doImportTableLobsInExtFile("APP", "BOOKS_IMP", fileName, 
-                                   null, null, null, 0);
+	    doImportTableLobsFromExtFile("APP", "BOOKS_IMP", fileName, 
+                                     null, null, null, 0);
         verifyData(" * ");
     }
 
     
     /*
      * Test import/export of all the columns using 
-     * SYSCS_EXPORT_QUERY and SYSCS_IMPORT_DATA procedures.  
+     * SYSCS_EXPORT_QUERY_LOBS_TO_EXTFILE and 
+     * SYSCS_IMPORT_DATA_LOBS_FROM_EXTFILE procedures.  
      */
     public void testImportDataExportQueryLobsInExtFile() 
         throws SQLException, IOException
     {
-        doExportQueryLobsInExtFile("select * from BOOKS", fileName,
+        doExportQueryLobsToExtFile("select * from BOOKS", fileName,
                                    null, null , null, lobsFileName);
-	    doImportDataLobsInExtFile(null, "BOOKS_IMP", null, null, fileName, 
+	    doImportDataLobsFromExtFile(null, "BOOKS_IMP", null, null, fileName, 
                                    null, null, null, 0);
         verifyData(" * ");
 
         // perform import with column names specified in random order.
-        doImportDataLobsInExtFile(null, "BOOKS_IMP", "PIC, CONTENT, NAME, ID", 
+        doImportDataLobsFromExtFile(null, "BOOKS_IMP", "PIC, CONTENT, NAME, ID", 
                                   "4, 3, 2, 1", fileName, null, null, null, 1);
         verifyData("PIC, CONTENT, NAME, ID");
 
         // test with  non-default delimiters. 
-        doExportQueryLobsInExtFile("select * from BOOKS_IMP", fileName,
+        doExportQueryLobsToExtFile("select * from BOOKS_IMP", fileName,
                                    ";", "%" , null, lobsFileName);
-	    doImportDataLobsInExtFile(null, "BOOKS_IMP", null, null, fileName, 
+	    doImportDataLobsFromExtFile(null, "BOOKS_IMP", null, null, fileName, 
                                   ";", "%", null, 1);
 
     }
@@ -297,27 +298,28 @@
 
     /*
      * Test import of only some columns of the table 
-     * using  SYSCS_EXPOR_QUERY and IMPORT_DATA procedures.  
+     * using  SYSCS_EXPOR_QUERY_LOBS_TO_EXTFILE and 
+     * SYSCS_IMPORT_DATA_LOBS_FROM_EXTFILE procedures.  
      */
     public void testImportDataExportQueryWithFewColsLobsInExtFile() 
         throws SQLException, IOException
     {
-        doExportQueryLobsInExtFile("select id, name, content, pic from BOOKS",
+        doExportQueryLobsToExtFile("select id, name, content, pic from BOOKS",
                                    fileName,  null, null, null, lobsFileName);
-        doImportDataLobsInExtFile(null, "BOOKS_IMP", "ID,PIC", "1 , 4",
-                                  fileName, null, null, null, 0);
+        doImportDataLobsFromExtFile(null, "BOOKS_IMP", "ID,PIC", "1 , 4",
+                                    fileName, null, null, null, 0);
         verifyData("ID,PIC");
-        doImportDataLobsInExtFile(null, "BOOKS_IMP", "ID, PIC, NAME", "1, 4, 2",
+        doImportDataLobsFromExtFile(null, "BOOKS_IMP", "ID, PIC, NAME", "1, 4, 2",
                                   fileName, null, null, null, 1);
         verifyData("ID, PIC, NAME");
-        doImportDataLobsInExtFile(null, "BOOKS_IMP", "ID, CONTENT, NAME", 
+        doImportDataLobsFromExtFile(null, "BOOKS_IMP", "ID, CONTENT, NAME", 
                                   "1, 3, 2", fileName, null, null, null, 1);
         verifyData("ID, CONTENT, NAME");
 
         // test with  non-default delimiters. 
-        doExportQueryLobsInExtFile("select id, name, content, pic from BOOKS",  
+        doExportQueryLobsToExtFile("select id, name, content, pic from BOOKS",  
                                    fileName,  "$", "!" , null, lobsFileName);
-        doImportDataLobsInExtFile(null, "BOOKS_IMP", "ID,PIC", "1 , 4",
+        doImportDataLobsFromExtFile(null, "BOOKS_IMP", "ID,PIC", "1 , 4",
                                   fileName, "$", "!", null, 0);
     }
 
@@ -330,20 +332,20 @@
          throws SQLException, IOException   
     {
         try {
-            doExportTableLobsInExtFile("APP", "BOOKS", fileName, 
+            doExportTableLobsToExtFile("APP", "BOOKS", fileName, 
                                        null, "9" , null, lobsFileName);
         } catch (SQLException e) {
             assertSQLState("XIE0J", e);
         }
 
         try {
-            doExportQueryLobsInExtFile("select * from BOOKS", fileName,
+            doExportQueryLobsToExtFile("select * from BOOKS", fileName,
                                        "|", "f", null, lobsFileName);
         } catch (SQLException e) {
             assertSQLState("XIE0J", e);
         }
 
-        doExportQueryLobsInExtFile("select * from BOOKS where id < 10", 
+        doExportQueryLobsToExtFile("select * from BOOKS where id < 10", 
                                    fileName, null, null, null, lobsFileName);
 
 
@@ -356,14 +358,14 @@
          */
 
         try {
-            doImportTableLobsInExtFile("APP", "BOOKS_IMP", fileName, "2", 
-                                       null, null, 0);
+            doImportTableLobsFromExtFile("APP", "BOOKS_IMP", fileName, "2", 
+                                         null, null, 0);
         } catch (SQLException e) {
              assertSQLState(JDBC.vmSupportsJDBC4() ? "38000": "XIE0J", e);
         }
 
         try {
-            doImportDataLobsInExtFile(null, "BOOKS_IMP", null, 
+            doImportDataLobsFromExtFile(null, "BOOKS_IMP", null, 
                                       null,  fileName, null, "c", null, 1);
         } catch (SQLException e) {
             assertSQLState(JDBC.vmSupportsJDBC4() ? "38000": "XIE0J", e);
@@ -435,13 +437,24 @@
         s.executeUpdate("insert into books values " + 
                         "(11, '212C3B24', '2422412221', " + 
                         "  cast (X'212421222C23B90A2124' as blob))");
+        // insert some clob data with default char delimiter inside 
+        // the data. It should get exported in double-delimiter format
+        // when exporting to the main export file. 
+        s.executeUpdate("insert into books values" +
+                        "(12, 'Transaction Processing' , " +
+                        "'This books covers \"Transaction\" \"processing\" concepts'"+
+                        ",cast (X'144594322143423214ab35f2e54e' as blob))");
+        s.executeUpdate("insert into books values" + 
+                        "(13, 'effective java' ," +  
+                        "'describes how to write \" quality java \" code', " +
+                        "cast (X'124594322143423214ab35f2e34c' as blob))");
 
         // insert some more randomly genrated data.
         Connection conn = s.getConnection();
         String sql = "insert into books values(? , ? , ? , ?)";
         PreparedStatement ps = conn.prepareStatement(sql);
         int blobSize = 0;
-        int id = 12;
+        int id = 14;
         for (int i = 0 ; i < 17 ; i++) {
             ps.setInt(1 , id++);
             ps.setString(2 , "book" +i);

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/tools/ieptests.sql
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/tools/ieptests.sql?view=diff&rev=523028&r1=523027&r2=523028
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/tools/ieptests.sql (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/tools/ieptests.sql Tue Mar 27 11:43:14 2007
@@ -531,92 +531,5 @@
 drop table inventory.orderTable;
 --end derby-390 related test cases.
 
----DERBY-378 , Add support to import/export of lobs
-
-create table books(id int , name varchar(30) , abstract clob(90), pic blob(100));
-
-create table imp_books(id int , name varchar(30),  abstract clob(90), pic blob(100));
-
-insert into books values(1, 'effective java' , 
-                        'describes how to write " quality java " code', 
-                         cast (X'124594322143423214ab35f2e34c' as blob));
-insert into books values(2, 'Apache Derby ' , 
-                         'This books covers Apache Derby Database Engine', 
-                         cast (X'134594322143423214ab35f2e44d' as blob));
-insert into books values(3, 'Transaction Processing' , 
-                         'This books covers "Transaction" "processing" concepts', 
-                          cast (X'144594322143423214ab35f2e54e' as blob));
-
-select * from books;
-
--- export lobs to an external file.
-call SYSCS_UTIL.SYSCS_EXPORT_TABLE_LOBS_IN_EXTFILE (null, 'BOOKS','extinout/books.dat', 
-                            null, null, null, 'extinout/books_lobs.dat') ;
-
--- import lobs stored in an external file. 
-call SYSCS_UTIL.SYSCS_IMPORT_TABLE_LOBS_IN_EXTFILE(null, 'IMP_BOOKS' , 
-                                      'extinout/books.dat', null, null, null, 0) ;
-
-select * from imp_books ;
-
--- import only some columns;
-call SYSCS_UTIL.SYSCS_IMPORT_DATA_LOBS_IN_EXTFILE(null, 
-                                    'IMP_BOOKS' ,'ID, ABSTRACT, PIC', '1,3,4',
-                                    'extinout/books.dat', null, null, null, 1) ;
-select * from imp_books;
-
--- import columns in different order, this will test reading lob data 
--- from the file in a random order.
-call SYSCS_UTIL.SYSCS_IMPORT_DATA_LOBS_IN_EXTFILE(null, 
-                                    'IMP_BOOKS' ,'PIC, ID, ABSTRACT, NAME', '4,1,3,2',
-                                    'extinout/books.dat', null, null, null, 1) ;
-
-select * from imp_books;
-
--- export using a query. 
-call SYSCS_UTIL.SYSCS_EXPORT_QUERY_LOBS_IN_EXTFILE('select * from books where id > 2', 
-             'extinout/books.dat' , null, null, null, 'extinout/books_lobs.dat') ;
-
-delete from imp_books where id > 2;
-call SYSCS_UTIL.SYSCS_IMPORT_TABLE_LOBS_IN_EXTFILE(null, 'IMP_BOOKS' , 
-                                      'extinout/books.dat' ,
-                                      null, null, null, 0) ;
-select * from imp_books;
-
-
--- export lob data also to given export file. This should write blob 
--- data in  hex format and clob data in double-delimiter to 
---  the export  file. 
-call SYSCS_UTIL.SYSCS_EXPORT_TABLE (null, 'BOOKS','extinout/books.dat', 
-                                          null, null, null) ;
-
-delete from imp_books;
-call SYSCS_UTIL.SYSCS_IMPORT_TABLE (null, 'IMP_BOOKS' , 'extinout/books.dat' ,
-                                      null, null, null, 0) ;
-
-select * from imp_books;
-
--- import only some columns;
-call SYSCS_UTIL.SYSCS_IMPORT_DATA(null, 'IMP_BOOKS' ,
-                                     'ID, ABSTRACT, PIC', '1,3,4',
-                                    'extinout/books.dat', null, null, null, 1) ;
-
-select * from imp_books;
-
--- export using a query. 
-call SYSCS_UTIL.SYSCS_EXPORT_QUERY('select * from books where id > 2', 
-                                    'extinout/books.dat' , null, null, null) ;
-delete from imp_books where id > 2;
-call SYSCS_UTIL.SYSCS_IMPORT_TABLE(null, 'IMP_BOOKS' , 'extinout/books.dat' ,
-                                  	    null, null, null, 0) ;
-select * from imp_books;
-
---drop table imp_books;
---drop table books;
-
----END DERBY-378 , Add support to import/export of lobs
-
-
-
 
 



Mime
View raw message