iepnegativetests.out

derby database source code.good for you.

ij> --testing error cases for import/export
create schema iep;
0 rows inserted/updated/deleted
ij> create table iep.t1(a int);
0 rows inserted/updated/deleted
ij> insert into iep.t1 values(100) , (101) , (102) , (103) , (104) , (105) , (106);
7 rows inserted/updated/deleted
ij> --export error cases
--export can not create file
call SYSCS_UTIL.SYSCS_EXPORT_TABLE ('IEP', 'T1' , 'nodir/t1.dat' , 
                                 null, null, null) ;
ERROR XIE0I: An IOException occurred while writing data to the file.
ij> --export table not found
call SYSCS_UTIL.SYSCS_EXPORT_TABLE ('IEP', 'NOTABLE' , 'extinout/t1.dat' , 
                                 null, null, null) ;
ERROR 38000: The exception 'SQL Exception: Table 'IEP.NOTABLE' does not exist.' was thrown while evaluating an expression.
ERROR 42X05: Table 'IEP.NOTABLE' does not exist.
ij> ---export schema is not valid
call SYSCS_UTIL.SYSCS_EXPORT_TABLE ('XXXX', 'T1' , 'extinout/t1.dat' , 
                                 null, null, null) ;
ERROR 38000: The exception 'SQL Exception: Schema 'XXXX' does not exist' was thrown while evaluating an expression.
ERROR 42Y07: Schema 'XXXX' does not exist
ij> --export query is invalid (syntax error)
call SYSCS_UTIL.SYSCS_EXPORT_QUERY('select from t1', 
                                    'extinout/t1.dat' , null, null, null) ;
ERROR 38000: The exception 'SQL Exception: Syntax error: Encountered "from" at line 1, column 8.' was thrown while evaluating an expression.
ERROR 42X01: Syntax error: Encountered "from" at line 1, column 8.
ij> --export codeset is invalid
call SYSCS_UTIL.SYSCS_EXPORT_QUERY('select * from iep.t1', 
                                    'extinout/t1.dat' , null, null, 'NOSUCHCODESET') ;
ERROR XIE0I: An IOException occurred while writing data to the file.
ij> call SYSCS_UTIL.SYSCS_EXPORT_TABLE ('XXXX', 'T1' , 'extinout/t1.dat' , 
                                 null, null, null) ;
ERROR 38000: The exception 'SQL Exception: Schema 'XXXX' does not exist' was thrown while evaluating an expression.
ERROR 42Y07: Schema 'XXXX' does not exist
ij> --export delimiter errror cases
--period can not be used as character ot column delimiter
call SYSCS_UTIL.SYSCS_EXPORT_TABLE ('IEP', 'T1' , 'extinout/t1.dat' , 
                                 null, '.', null) ;
ERROR XIE0K: The period was specified as a character string delimiter.
ij> call SYSCS_UTIL.SYSCS_EXPORT_TABLE ('IEP', 'T1' , 'extinout/t1.dat' , 
                                 '.', null, null) ;
ERROR XIE0J: A delimiter is not valid or is used more than once.
ij> --same delimter can not be used as character and column delimters
call SYSCS_UTIL.SYSCS_EXPORT_TABLE ('IEP', 'T1' , 'extinout/t1.dat' , 
                                 ';', ';', null) ;
ERROR XIE0J: A delimiter is not valid or is used more than once.
ij> --space character can not be a delimiter
call SYSCS_UTIL.SYSCS_EXPORT_TABLE ('IEP', 'T1' , 'extinout/t1.dat' , 
                                 ' ', ';', null) ;
ERROR XIE0J: A delimiter is not valid or is used more than once.
ij> call SYSCS_UTIL.SYSCS_EXPORT_TABLE ('IEP', 'T1' , 'extinout/t1.dat' , 
                                 null, ' ', null) ;
ERROR XIE0J: A delimiter is not valid or is used more than once.
ij> --if emtry strinng is passed actual value delimiter should be space
--and the that should become a invalid delimiter 
call SYSCS_UTIL.SYSCS_EXPORT_TABLE ('IEP', 'T1' , 'extinout/t1.dat' , 
                                 '', ';', null) ;
ERROR XIE0J: A delimiter is not valid or is used more than once.
ij> call SYSCS_UTIL.SYSCS_EXPORT_TABLE ('IEP', 'T1' , 'extinout/t1.dat' , 
                                 null, '', null) ;
ERROR XIE0J: A delimiter is not valid or is used more than once.
ij> --more than one character passed to the delimiters get truncated to one
--following one should give error because eventually '\' delimiter 
--is used a both for char and col
call SYSCS_UTIL.SYSCS_EXPORT_TABLE ('IEP', 'T1' , 'extinout/t1.dat' , 
                                 '\a', '\', null) ;
ERROR XIE0J: A delimiter is not valid or is used more than once.
ij> --DO A VALID EXPORT AND  IMPORT 
set schema iep;
0 rows inserted/updated/deleted
ij> call SYSCS_UTIL.SYSCS_EXPORT_TABLE ('IEP', 'T1' , 'extinout/t1.dat' , 
                                 null, null, 'utf-8') ;
0 rows inserted/updated/deleted
ij> delete from t1 ;
7 rows inserted/updated/deleted
ij> call SYSCS_UTIL.SYSCS_IMPORT_TABLE('IEP', 'T1' , 'extinout/t1.dat' , 
                                 null, null, null, 0) ;
0 rows inserted/updated/deleted
ij> select * from t1;
A          
-----------
100        
101        
102        
103        
104        
105        
106        
ij> --import error cases
--import can not find input file
call SYSCS_UTIL.SYSCS_IMPORT_TABLE('IEP', 'T1' , 'nodir/t1.dat' , 
                                 null, null, null, 0) ;
ERROR 38000: The exception 'SQL Exception: The exception 'java.lang.reflect.InvocationTargetException' was thrown while evaluating an expression.' was thrown while evaluating an expression.
ERROR 38000: The exception 'java.lang.reflect.InvocationTargetException' was thrown while evaluating an expression.
ERROR XJ001: Java exception: ': java.lang.reflect.InvocationTargetException'.
ERROR XIE04: Data file not found: nodir/t1.dat
ij> --import table not found
call SYSCS_UTIL.SYSCS_IMPORT_TABLE ('IEP', 'NOTABLE' , 'extinout/t1.dat' , 
                                 null, null, null, 0) ;
ERROR XIE0M: Table 'IEP.NOTABLE' does not exist.  
ij> --import schema is not valid
call SYSCS_UTIL.SYSCS_IMPORT_TABLE ('XXXX', 'T1' , 'extinout/t1.dat' , 
                                 null, null, null, 0) ;
ERROR XIE0M: Table 'XXXX.T1' does not exist.  
ij> call SYSCS_UTIL.SYSCS_IMPORT_TABLE ('IEP', 'T1' , 'extinout/t1.dat' , 
                                 null, null, 'INCORRECTCODESET', 0) ;
ERROR 38000: The exception 'SQL Exception: The exception 'java.lang.reflect.InvocationTargetException' was thrown while evaluating an expression.' was thrown while evaluating an expression.
ERROR 38000: The exception 'java.lang.reflect.InvocationTargetException' was thrown while evaluating an expression.
ERROR XJ001: Java exception: ': java.lang.reflect.InvocationTargetException'.
ERROR XJ001: Java exception: 'java.io.UnsupportedEncodingException: INCORRECTCODESET'.
ij> --check import with invalid delimiter usage
--if emtry strinng is passed actual value delimiter should be space
--and the that should become a invalid delimiter 
call SYSCS_UTIL.SYSCS_IMPORT_TABLE ('IEP', 'T1' , 'extinout/t1.dat' , 
                                 '', ';', null, 0) ;
ERROR 38000: The exception 'SQL Exception: The exception 'java.lang.reflect.InvocationTargetException' was thrown while evaluating an expression.' was thrown while evaluating an expression.
ERROR 38000: The exception 'java.lang.reflect.InvocationTargetException' was thrown while evaluating an expression.
ERROR XJ001: Java exception: ': java.lang.reflect.InvocationTargetException'.
ERROR XIE0J: A delimiter is not valid or is used more than once.
ij> call SYSCS_UTIL.SYSCS_IMPORT_TABLE ('IEP', 'T1' , 'extinout/t1.dat' , 
                                 null, '', null, 0) ;
ERROR 38000: The exception 'SQL Exception: The exception 'java.lang.reflect.InvocationTargetException' was thrown while evaluating an expression.' was thrown while evaluating an expression.
ERROR 38000: The exception 'java.lang.reflect.InvocationTargetException' was thrown while evaluating an expression.
ERROR XJ001: Java exception: ': java.lang.reflect.InvocationTargetException'.
ERROR XIE0J: A delimiter is not valid or is used more than once.
ij> --same delimter can not be used as character and column delimters
call SYSCS_UTIL.SYSCS_IMPORT_TABLE ('IEP', 'T1' , 'extinout/t1.dat' , 
                                 ';', ';', null, 1) ;
ERROR 38000: The exception 'SQL Exception: The exception 'java.lang.reflect.InvocationTargetException' was thrown while evaluating an expression.' was thrown while evaluating an expression.
ERROR 38000: The exception 'java.lang.reflect.InvocationTargetException' was thrown while evaluating an expression.
ERROR XJ001: Java exception: ': java.lang.reflect.InvocationTargetException'.
ERROR XIE0J: A delimiter is not valid or is used more than once.
ij> autocommit off;
ij> create table v1(a int) ;
0 rows inserted/updated/deleted
ij> declare global temporary table session.temp1(c1 int) on commit preserve rows not logged;
0 rows inserted/updated/deleted
ij> insert into session.temp1 values(1) , (2) , (3) , (4) , (5) , (6);
6 rows inserted/updated/deleted
ij> select * from session.temp1;
C1         
-----------
1          
2          
3          
4          
5          
6          
ij> --export to from a temporary table
call SYSCS_UTIL.SYSCS_EXPORT_TABLE ('SESSION', 'TEMP1' , 'extinout/temp1.dat' , 
                           null, null, null) ;
0 rows inserted/updated/deleted
ij> -- because temporary table has on commit preserve rows, commit issued by export will not delete data from the temp table.
select * from session.temp1;
C1         
-----------
1          
2          
3          
4          
5