test/tools/csql/exp.testnw003.ksh

   1 Network CSql
   2 echo UPDATE and DELETE testing;
   3 Statement Executed
   4 Statement Executed: Rows Affected = 1
   5 Statement Executed: Rows Affected = 1
   6 Statement Executed: Rows Affected = 1
   7 Statement Executed: Rows Affected = 1
   8 Statement Executed: Rows Affected = 1
   9 Statement Executed: Rows Affected = 1
  10 echo select * from t1;
  11 ---------------------------------------------------------
  12         t1.f1   t1.f2
  13 ---------------------------------------------------------
  14         10      20
  15         11      21
  16         12      22
  17         13      23
  18         14      24
  19         50      50
  20
  21 echo select * from t1 where f1 = 100;
  22 ---------------------------------------------------------
  23         t1.f1   t1.f2
  24 ---------------------------------------------------------
  25         50      50
  26
  27 echo update t1 set f2 = 100;
  28 Statement Executed: Rows Affected = 6
  29 echo select * from t1;
  30 ---------------------------------------------------------
  31         t1.f1   t1.f2
  32 ---------------------------------------------------------
  33         10      100
  34         11      100
  35         12      100
  36         13      100
  37         14      100
  38         50      100
  39
  40 echo update t1 set f2 = 200 where f1 =50;
  41 Statement Executed: Rows Affected = 1
  42 echo select * from t1;
  43 ---------------------------------------------------------
  44         t1.f1   t1.f2
  45 ---------------------------------------------------------
  46         10      100
  47         11      100
  48         12      100
  49         13      100
  50         14      100
  51         50      200
  52
  53 echo delete from t1 where f1 = 50;
  54 Statement Executed: Rows Affected = 1
  55 echo select * from t1;
  56 ---------------------------------------------------------
  57         t1.f1   t1.f2
  58 ---------------------------------------------------------
  59         10      100
  60         11      100
  61         12      100
  62         13      100
  63         14      100
  64
  65 echo delete from t1;
  66 Statement Executed: Rows Affected = 5
  67 echo select * from t1;
  68 ---------------------------------------------------------
  69         t1.f1   t1.f2
  70 ---------------------------------------------------------
  71
  72 Statement Executed