test/cache/MultiDsn/Gateway/exp.test023.ksh

   1 Entries made for myodbc3  in csqlds.conf file.
   2 Entries made for psql in csqlds.conf file.
   3 Table 't1 and t2' is created in myodbc3
   4 SELECT records from myodbc3
   5 +---------------------------------------+
   6 | Connected!                            |
   7 |                                       |
   8 | sql-statement                         |
   9 | help [tablename]                      |
  10 | quit                                  |
  11 |                                       |
  12 +---------------------------------------+
  13 \e[?1034hSQL> select * from t1;
  14 +-----------+---------------------+
  15 | f1        | f2                  |
  16 +-----------+---------------------+
  17 | 1         | Hi                  |
  18 | 2         | Hello               |
  19 | 3         | Hi All              |
  20 +-----------+---------------------+
  21 SQLRowCount returns 3
  22 3 rows fetched
  23 SQL> select * from t2;
  24 +-----------+---------------------+
  25 | f1        | f2                  |
  26 +-----------+---------------------+
  27 | 10        | mysql               |
  28 | 20        | open                |
  29 | 30        | source              |
  30 +-----------+---------------------+
  31 SQLRowCount returns 3
  32 3 rows fetched
  33 SQL>
  34 Table 'tt1 and tt2' is created in psql
  35 SELECT records from psql
  36 +---------------------------------------+
  37 | Connected!                            |
  38 |                                       |
  39 | sql-statement                         |
  40 | help [tablename]                      |
  41 | quit                                  |
  42 |                                       |
  43 +---------------------------------------+
  44 \e[?1034hSQL> select * from tt1;
  45 +------------+-----------+
  46 | f1         | f2        |
  47 +------------+-----------+
  48 | 11         | one       |
  49 | 22         | two       |
  50 | 33         | three     |
  51 +------------+-----------+
  52 SQLRowCount returns 3
  53 3 rows fetched
  54 SQL> select * from tt2;
  55 +------------+-----------+
  56 | f1         | f2        |
  57 +------------+-----------+
  58 | 1111       | psql      |
  59 | 2222       | open      |
  60 | 3333       | source    |
  61 +------------+-----------+
  62 SQLRowCount returns 3
  63 3 rows fetched
  64 SQL>
  65 Table t1 is cached from myodbc3.
  66 Table 'tt1' is cached from psql.
  67
  68 DELETE records from tables using Gateway(csql -g)
  69 DELETE records from t1 and t2 table.
  70 Statement Executed: Rows Affected = 1
  71 Statement Executed: Rows Affected = 1
  72 Statement Executed: Rows Affected = 1
  73 Statement Executed: Rows Affected = 1
  74 DELETE records from tt1 and tt2 table.
  75 Statement Executed: Rows Affected = 1
  76 Statement Executed: Rows Affected = 1
  77 Statement Executed: Rows Affected = 1
  78 Statement Executed: Rows Affected = 1
  79
  80 SELECT records from cached and non-cached tables using Gateway(csql -g)
  81 select 't1' and 't2' table.
  82 ---------------------------------------------------------
  83         t1.f1   t1.f2
  84 ---------------------------------------------------------
  85         3       Hi All
  86
  87 ---------------------------------------------------------
  88         f1      f2
  89 ---------------------------------------------------------
  90         30      source
  91
  92 select 'tt1' and 'tt2' table.
  93 ---------------------------------------------------------
  94         tt1.f1  tt1.f2
  95 ---------------------------------------------------------
  96         33      three
  97
  98 ---------------------------------------------------------
  99         f1      f2
 100 ---------------------------------------------------------
 101         3333    source
 102