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

   1 Table t1 and t2 created in target DB.
   2 cachetable -t t5 -D
   3 cachetable -t t6 -D
   4 select query on t1 and t2 table
   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 ---------------------------------------------------------
  10         t5.f1   t5.f2
  11 ---------------------------------------------------------
  12
  13 ---------------------------------------------------------
  14         t6.f1   t6.f2
  15 ---------------------------------------------------------
  16
  17 +---------------------------------------+
  18 | Connected!                            |
  19 |                                       |
  20 | sql-statement                         |
  21 | help [tablename]                      |
  22 | quit                                  |
  23 |                                       |
  24 +---------------------------------------+
  25 SQL> +-----------+-----------+
  26 | f1        | f2        |
  27 +-----------+-----------+
  28 | 15        | 20        |
  29 | 16        | 21        |
  30 +-----------+-----------+
  31 SQLRowCount returns 2
  32 2 rows fetched
  33 SQL> +-----------+-----------+
  34 | f1        | f2        |
  35 +-----------+-----------+
  36 | 15        | 20        |
  37 | 16        | 21        |
  38 +-----------+-----------+
  39 SQLRowCount returns 2
  40 2 rows fetched
  41 SQL>