test/cache/CacheTable/exp.test045.ksh.SunOS

   1 CREATING TABLE t1 and INSERTING 1 RECORDS IN TARGET DB
   2 +---------------------------------------+
   3 | Connected!                            |
   4 |                                       |
   5 | sql-statement                         |
   6 | help [tablename]                      |
   7 | quit                                  |
   8 |                                       |
   9 +---------------------------------------+
  10 SQL> SQL> SQLRowCount returns 0
  11 SQL> SQL> SQLRowCount returns 1
  12 SQL> SQL> +-----------+
  13 | f1        |
  14 +-----------+
  15 | 1         |
  16 +-----------+
  17 SQLRowCount returns 1
  18 1 rows fetched
  19 SQL> CREATING TABLE t1 and INSERTING 1 RECORDS AT CSQL
  20 echo create table t1(f1 int);
  21 Statement Executed
  22 echo insert into t1 values(2);
  23 Statement Executed: Rows Affected = 1
  24 echo select * from t1;
  25 ---------------------------------------------------------
  26         t1.f1
  27 ---------------------------------------------------------
  28         2
  29
  30 AFTER INSERT AT CSQL DATA IN TDB
  31 +---------------------------------------+
  32 | Connected!                            |
  33 |                                       |
  34 | sql-statement                         |
  35 | help [tablename]                      |
  36 | quit                                  |
  37 |                                       |
  38 +---------------------------------------+
  39 SQL> SQL> +-----------+
  40 | f1        |
  41 +-----------+
  42 | 1         |
  43 +-----------+
  44 SQLRowCount returns 1
  45 1 rows fetched
  46 SQL> echo drop table t1;
  47 Statement Executed
  48 +---------------------------------------+
  49 | Connected!                            |
  50 |                                       |
  51 | sql-statement                         |
  52 | help [tablename]                      |
  53 | quit                                  |
  54 |                                       |
  55 +---------------------------------------+
  56 SQL> SQL> SQLRowCount returns 0
  57 SQL>