SELECT with different databases

Classic Servoy
1

is there a way to perform a query using multiple database?
As far as I can see, you can make queries only within one database.

Something like```
SELECT * FROM db1.tableA, db2.tableB

2

A join over several database will not work. You can use Servoy relations for that, however. If your form is based on db1.tableA you can have a relation to db2.tableB and get related data. But, of course, you cannot search properly over this kind of relation…

3

Some databases will allow this. Oracle for example and if I’m not mistaken iAnywhere also allows this if you use link tables but I’m not 100% sure.

4

Yes, that means the SAME database vendor. And in that situation: why would you have two databases then?

5

patrick:
Yes, that means the SAME database vendor. And in that situation: why would you have two databases then?

Becoz one is the log server and the other is a normal database

6

patrick:
Yes, that means the SAME database vendor. And in that situation: why would you have two databases then?

Becoz one is the log server database and the other is a normal database

7

OK. And when both are the same db vendor, you can follow Jan’s advice and try to link the tables.

8

ASA (SQL Anywhere) has the concept of a Proxy Table, which is a table in a different database. This other database could be a Sybase database or non-Sybase database. It can be located on the same machine, or a different one. We specifically support:

  • Sybase SQL Anywhere
  • Sybase ASE
  • Oracle
  • IBM DB2 UDB
  • Microsoft SQL Server

We also have a connector to a “generic” database that supports ODBC or JDBC.

Proxy tables are treated like a regular, local table within an ASA (SQL Anywhere) database. This means that you can run queries, updates, inserts, joins, etc. across the proxy tables.

The online documentation outlines how to create and use proxy tables:
http://www.ianywhere.com/developer/prod … 000595.htm

David