test/cache/MultiDsn/Gateway/exp.test001.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 Select records using Gateway(csql -g)
  69 select records from t1 and t2
  70 ---------------------------------------------------------
  71         t1.f1   t1.f2
  72 ---------------------------------------------------------
  73         1       Hi
  74         2       Hello
  75         3       Hi All
  76
  77 ---------------------------------------------------------
  78         f1      f2
  79 ---------------------------------------------------------
  80         10      mysql
  81         20      open
  82         30      source
  83
  84 select records from tt1 and tt2.
  85 ---------------------------------------------------------
  86         tt1.f1  tt1.f2
  87 ---------------------------------------------------------
  88         11      one
  89         22      two
  90         33      three
  91
  92 ---------------------------------------------------------
  93         f1      f2
  94 ---------------------------------------------------------
  95         1111    psql
  96         2222    open
  97         3333    source
  98