Kbase P25002: Is It Possible to Query Two Databases in SQL Explorer?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/5/2010 |
|
Status: Verified
GOAL:
Is It Possible to Query Two Databases in SQL Explorer?
GOAL:
Can I use SQLExplorer to query more than one database at a time?
FACT(s) (Environment):
Progress 9.1x
OpenEdge 10.x
All Supported Operating Systems
FIX:
When working with the SQL Explorer, the need might arise to query more
than one database at a time.
The SQL Explorer is a tool intended for browsing a database and for
testing queries. It can also be used for minor database maintenance
or administrative tasks.
The SQL Explorer is intentionally limited in scope and not intended
for building applications to accomplish heavy-duty maintenance. It is
for primarily viewing a database.
Although JDBC or ODBC can be used to connect to more than one database
at a time from an application, there is currently no capability to do
queries that refer to more than one database. All of the SQL is
executed in the SQL Server; however, each SQL Server serves exactly
one database.