Kbase P89995: Is it possible to run a VIEW against a database other than the one currently connected to via SQL-92
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
3/13/2009 |
|
Status: Verified
GOAL:
Is it possible to run a VIEW against a database other than the one currently connected to via SQL-92?
FACT(s) (Environment):
Progress 9.1x
OpenEdge 10.x
FIX:
No. SQL-92 allows for only one concurrent database connection at a time.
In order to create this VIEW against another database, you must connect to that database and run the 'CREATE VIEW' statement.