test/cache/MultiDsn/Connection/exp.test006.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>
  23 Table 't10' is created in psql
  24 +---------------------------------------+
  25 | Connected!                            |
  26 |                                       |
  27 | sql-statement                         |
  28 | help [tablename]                      |
  29 | quit                                  |
  30 |                                       |
  31 +---------------------------------------+
  32 \e[?1034hSQL> select * from t10;
  33 +------------+-----------+
  34 | f1         | f2        |
  35 +------------+-----------+
  36 | 1          | one       |
  37 | 2          | two       |
  38 | 3          | three     |
  39 +------------+-----------+
  40 SQLRowCount returns 3
  41 3 rows fetched
  42 SQL>
  43 Table t1 is cached from myodbc3.
  44 select * from t1
  45 ---------------------------------------------------------
  46         t1.f1   t1.f2
  47 ---------------------------------------------------------
  48         100     Hi
  49         200     Hello
  50         300     Hi All
  51
  52
  53 Table 't10' is cached from psql.
  54 select * from t10.
  55 ---------------------------------------------------------
  56         t10.f1  t10.f2
  57 ---------------------------------------------------------
  58         1       one
  59         2       two
  60         3       three
  61