Kbase P15121: How to select the working database from within the 4GL
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
05/06/2008 |
|
Status: Verified
GOAL:
How to select the working database from within the 4GL
GOAL:
What is the DICTDB alias
GOAL:
When DICTDB gets created?
FACT(s) (Environment):
Progress 9.x
OpenEdge 10.x
FIX:
When Progress client session starts it creates the DICTDB alias for the first database connection. The exception to this is if logical database name is TEMP-DB, in which case DICTDB is created for the second database connection (if any).
In order to use metaschema files and Virtual System Tables, many customers would like to select the working database from within the 4GL and not the Dictionary. The Dictionary only works with one database at a time, even if more than one database is connected. That database has the "DICTDB" logical name or alias.
The statement to use to select a working database from the 4GL is the following:
CREATE ALIAS DICTDB FOR DATABASE my_db.
Where my_db is the logical name of my database. This statement must be run in a separate procedure than the procedure which will actually access the metaschema files.