📄 ieptests.out
字号:
CREATE TABLE TTYPES(DATETYPE DATE, TIMETYPE TIME, TSTAMPTYPE TIMESTAMP );0 rows inserted/updated/deletedij> insert into ttypes values('1999-09-09' , '12:15:19' , 'xxxxxxFILTERED-TIMESTAMPxxxxx);1 row inserted/updated/deletedij> insert into ttypes values('2999-12-01' , '13:16:10' , 'xxxxxxFILTERED-TIMESTAMPxxxxx);1 row inserted/updated/deletedij> insert into ttypes values('3000-11-02' , '14:17:21' , 'xxxxxxFILTERED-TIMESTAMPxxxxx);1 row inserted/updated/deletedij> insert into ttypes values('2004-04-03' , '15:18:31' , 'xxxxxxFILTERED-TIMESTAMPxxxxx);1 row inserted/updated/deletedij> insert into ttypes values(null , null , null);1 row inserted/updated/deletedij> call SYSCS_UTIL.SYSCS_EXPORT_TABLE (null, 'TTYPES' , 'extinout/ttypes.del' , null, null, null) ;0 rows inserted/updated/deletedij> call SYSCS_UTIL.SYSCS_IMPORT_TABLE (null, 'TTYPES' , 'extinout/ttypes.del' , null, null, null, 0) ;0 rows inserted/updated/deletedij> select * from ttypes;DATETYPE |TIMETYPE|TSTAMPTYPE ----------------------------------------------1999-09-09|12:15:19|xxxxxxFILTERED-TIMESTAMPxxxxx2999-12-01|13:16:10|xxxxxxFILTERED-TIMESTAMPxxxxx3000-11-02|14:17:21|xxxxxxFILTERED-TIMESTAMPxxxxx2004-04-03|15:18:31|xxxxxxFILTERED-TIMESTAMPxxxxxNULL |NULL |NULL 1999-09-09|12:15:19|xxxxxxFILTERED-TIMESTAMPxxxxx2999-12-01|13:16:10|xxxxxxFILTERED-TIMESTAMPxxxxx3000-11-02|14:17:21|xxxxxxFILTERED-TIMESTAMPxxxxx2004-04-03|15:18:31|xxxxxxFILTERED-TIMESTAMPxxxxxNULL |NULL |NULL ij> ---Import should commit on success and rollback on any failuresautocommit off ;ij> create table t1(a int ) ;0 rows inserted/updated/deletedij> insert into t1 values(1) ;1 row inserted/updated/deletedij> insert into t1 values(2) ;1 row inserted/updated/deletedij> call SYSCS_UTIL.SYSCS_EXPORT_TABLE (null, 'T1' , 'extinout/t1.del' , null, null, null) ;0 rows inserted/updated/deletedij> call SYSCS_UTIL.SYSCS_IMPORT_TABLE (null, 'T1' , 'extinout/t1.del' , null, null, null, 0) ;0 rows inserted/updated/deletedij> --above import should have committed , following rollback should be a noop.rollback;ij> select * from t1;A -----------1 2 1 2 ij> insert into t1 values(3) ;1 row inserted/updated/deletedij> insert into t1 values(4) ;1 row inserted/updated/deletedij> --file not found error should rollback call SYSCS_UTIL.SYSCS_IMPORT_TABLE (null, 'T1' , 'extinout/nofile.del' , 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: extinout/nofile.delij> commit;ij> select * from t1 ;A -----------1 2 1 2 ij> insert into t1 values(3) ;1 row inserted/updated/deletedij> insert into t1 values(4) ;1 row inserted/updated/deletedij> --table not found error should issue a implicit rollback call SYSCS_UTIL.SYSCS_IMPORT_TABLE (null, 'NOTABLE' , 'extinout/t1.del' , null, null, null, 0) ;ERROR XIE0M: Table 'NOTABLE' does not exist. ij> commit ;ij> select * from t1 ;A -----------1 2 1 2 ij> delete from t1;4 rows inserted/updated/deletedij> ---check commit/rollback with replace options using insert into t1 values(1) ;1 row inserted/updated/deletedij> insert into t1 values(2) ;1 row inserted/updated/deletedij> call SYSCS_UTIL.SYSCS_EXPORT_TABLE (null, 'T1' , 'extinout/t1.del' , null, null, null) ;0 rows inserted/updated/deletedij> --above export should have a commit.rollback below should be a nooprollback;ij> select * from t1;A -----------1 2 ij> call SYSCS_UTIL.SYSCS_IMPORT_TABLE (null, 'T1' , 'extinout/t1.del' , null, null, null, 1) ;0 rows inserted/updated/deletedij> --above import should have committed , following rollback should be a noop.rollback;ij> select * from t1;A -----------1 2 ij> insert into t1 values(3) ;1 row inserted/updated/deletedij> insert into t1 values(4) ;1 row inserted/updated/deletedij> --file not found error should rollback call SYSCS_UTIL.SYSCS_IMPORT_TABLE (null, 'T1' , 'extinout/nofile.del' , null, null, 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 XIE04: Data file not found: extinout/nofile.delij> commit;ij> select * from t1 ;A -----------1 2 ij> insert into t1 values(3) ;1 row inserted/updated/deletedij> insert into t1 values(4) ;1 row inserted/updated/deletedij> --table not found error should issue a implicit rollback call SYSCS_UTIL.SYSCS_IMPORT_TABLE (null, 'NOTABLE' , 'extinout/t1.del' , null, null, null, 1) ;ERROR XIE0M: Table 'NOTABLE' does not exist. ij> commit ;ij> ---check IMPORT_DATA calls commit/rollbackselect * from t1 ;A -----------1 2 ij> delete from t1;2 rows inserted/updated/deletedij> ---check commit/rollback with replace options using insert into t1 values(1) ;1 row inserted/updated/deletedij> insert into t1 values(2) ;1 row inserted/updated/deletedij> call SYSCS_UTIL.SYSCS_EXPORT_TABLE (null, 'T1' , 'extinout/t1.del' , null, null, null) ;0 rows inserted/updated/deletedij> call SYSCS_UTIL.SYSCS_IMPORT_DATA(null, 'T1' , 'A' , '1' , 'extinout/t1.del' , null, null, null, 0) ;0 rows inserted/updated/deletedij> --above import should have committed , following rollback should be a noop.rollback;ij> select * from t1;A -----------1 2 1 2 ij> insert into t1 values(3) ;1 row inserted/updated/deletedij> insert into t1 values(4) ;1 row inserted/updated/deletedij> --file not found error should rollback call SYSCS_UTIL.SYSCS_IMPORT_DATA(null, 'T1', 'A' , '1' , 'extinout/nofile.del' , 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: extinout/nofile.delij> commit;ij> select * from t1 ;A -----------1 2 1 2 ij> insert into t1 values(3) ;1 row inserted/updated/deletedij> insert into t1 values(4) ;1 row inserted/updated/deletedij> --table not found error should issue a implicit rollback call SYSCS_UTIL.SYSCS_IMPORT_DATA(null, 'NOTABLE' , 'A' , '1', 'extinout/t1.del' , null, null, null, 1) ;ERROR XIE0M: Table 'NOTABLE' does not exist. ij> commit ;ij> select * from t1 ;A -----------1 2 1 2 ij> autocommit on ;ij> --make sure commit import code is ok in autcommit mode.insert into t1 values(3) ;1 row inserted/updated/deletedij> insert into t1 values(4) ;1 row inserted/updated/deletedij> call SYSCS_UTIL.SYSCS_IMPORT_DATA(null, 'T1' , 'A' , '1' , 'extinout/t1.del' , null, null, null, 0) ;0 rows inserted/updated/deletedij> select * from t1 ;A -----------1 2 1 2 3 4 1 2 ij> insert into t1 values(5) ;1 row inserted/updated/deletedij> insert into t1 values(6) ;1 row inserted/updated/deletedij> --following import will back , but should not have any impact on insertscall SYSCS_UTIL.SYSCS_IMPORT_DATA(null, 'T1', 'A' , '1' , 'extinout/nofile.del' , null, null, null, 0) ;⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -