test/sql/DDL/exp.test002.ksh

   1 echo create table t1(f1 bigint, f2 int, f3 smallint, f4 tinyint, f5 char(10), f6 varchar(10), f7 float,f8 double, f9 time, f10 date, f11 timestamp);
   2 Statement Executed
   3 echo set autocommit off;
   4 AUTOCOMMIT Mode is set to OFF
   5 Statement Executed: Rows Affected = 1
   6 Statement Executed: Rows Affected = 1
   7 Statement Executed: Rows Affected = 1
   8 echo select * from t1;
   9 ---------------------------------------------------------
  10         t1.f1   t1.f2   t1.f3   t1.f4   t1.f5   t1.f6   t1.f7   t1.f8   t1.f9   t1.f10  t1.f11
  11 ---------------------------------------------------------
  12         1001    101     11      1       CSQL1   Lakshya1        2010.000000     5012010.000000  10:0:0.0        2010/1/5        2010/1/5 10:0:0.0
  13         1002    102     12      2       CSQL2   Lakshya2        2010.000000     5012010.000000  10:0:0.0        2010/2/5        2010/2/5 10:0:0.0
  14         1003    103     13      3       CSQL3   Lakshya3        2010.000000     5012010.000000  10:0:0.0        2010/3/5        2010/3/5 10:0:0.0
  15
  16 echo truncate table t1;
  17 Statement Executed: Rows Affected = 3
  18 echo rollback;
  19 echo select * from t1;
  20 ---------------------------------------------------------
  21         t1.f1   t1.f2   t1.f3   t1.f4   t1.f5   t1.f6   t1.f7   t1.f8   t1.f9   t1.f10  t1.f11
  22 ---------------------------------------------------------
  23
  24 Statement Executed