test/cache/MultiDsn/Connection/exp.test001.ksh

   1 Entries made for myodbc3  in csqlds.conf file.
   2 Entries made for psql in csqlds.conf file.
   3 Table 't1' is created in myodbc3
   4 +---------------------------------------+
   5 | Connected!                            |
   6 |                                       |
   7 | sql-statement                         |
   8 | help [tablename]                      |
   9 | quit                                  |
  10 |                                       |
  11 +---------------------------------------+
  12 \e[?1034hSQL> select * from t1;
  13 +-----------+-----------+
  14 | f1        | f2        |
  15 +-----------+-----------+
  16 | 100       | Hi        |
  17 | 200       | Hello     |
  18 | 300       | Hi All    |
  19 +-----------+-----------+
  20 SQLRowCount returns 3
  21 3 rows fetched
  22 SQL> Table 't10' is created in psql
  23 +---------------------------------------+
  24 | Connected!                            |
  25 |                                       |
  26 | sql-statement                         |
  27 | help [tablename]                      |
  28 | quit                                  |
  29 |                                       |
  30 +---------------------------------------+
  31 \e[?1034hSQL> select * from t10;
  32 +------------+-----------+
  33 | f1         | f2        |
  34 +------------+-----------+
  35 | 1          | one       |
  36 | 2          | two       |
  37 | 3          | three     |
  38 +------------+-----------+
  39 SQLRowCount returns 3
  40 3 rows fetched
  41 SQL> Table t1 is cached from myodbc3.
  42 select * from t1
  43 ---------------------------------------------------------
  44         t1.f1   t1.f2
  45 ---------------------------------------------------------
  46         100     Hi
  47         200     Hello
  48         300     Hi All
  49
  50 Table 't10' is cached from psql.
  51 select * from t10.
  52 ---------------------------------------------------------
  53         t10.f1  t10.f2
  54 ---------------------------------------------------------
  55         1       one
  56         2       two
  57         3       three
  58