test/tools/csql/exp.test083.ksh

   1 echo create table t1(f1 int,f2 char(10));
   2 Statement Executed
   3 echo insert into t1 values(1,'x');
   4 Statement Executed: Rows Affected = 1
   5 echo insert into t1 values(2,'y');
   6 Statement Executed: Rows Affected = 1
   7 echo set autocommit off;
   8 AUTOCOMMIT Mode is set to OFF
   9 echo update t1 set f2='k' where f1=2;
  10 Statement Executed: Rows Affected = 1
  11 echo select * from t1;
  12 ---------------------------------------------------------
  13         t1.f1   t1.f2
  14 ---------------------------------------------------------
  15         1       x
  16         2       k
  17
  18 echo rollback;
  19 echo select * from t1;
  20 ---------------------------------------------------------
  21         t1.f1   t1.f2
  22 ---------------------------------------------------------
  23         1       x
  24         2       y
  25
  26 echo insert into t1 values(3,'k');
  27 Statement Executed: Rows Affected = 1
  28 echo insert into t1 values(4,'p');
  29 Statement Executed: Rows Affected = 1
  30 echo commit;
  31 echo insert into t1 values(5,'t');
  32 Statement Executed: Rows Affected = 1
  33 echo rollback;
  34 echo select * from t1;
  35 ---------------------------------------------------------
  36         t1.f1   t1.f2
  37 ---------------------------------------------------------
  38         1       x
  39         2       y
  40         3       k
  41         4       p
  42
  43 Statement Executed