Kbase P3299: How to access Data Administration and/ or Dictionary Dictionary with Runtime or Database Only Licens
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/8/2008 |
|
Status: Verified
GOAL:
How to load an incremental .df into a runtime database
GOAL:
How to accesses Data Administration and/or Data Dictionary menu's with a Runtime client or Database license.
GOAL:
How to access the menu's that appeared grayed out in Data Dictionary and/or Data Administration.
FACT(s) (Environment):
All Supported Operating Systems
Progress/OpenEdge Versions
FIX:
Start the client session with -rx parameter to access the Data Dictionary or Administration menus to administer database schema and security.
The Data Dictionary and Administration functions and files are available on ALL Progress client and database products. However, if you have purchased a "run-time-only" client or only a database product you may think you cannot access this functionality.
To access the Data Dictionary and Administration functions you must start your session with the -rx parameter. Using the -rx parameter will allow you to get to the editor. You can then move to the tool bar and gain access to the Data Dictionary and Data Administration functions. (Or you can use -rx -p _dict.p to gain access directly to the dictionary) This will allow you to manage your database schema and security as well as dump and load data definition files(.df). The -rx parameter also allows you to compile encrypted code.
Examples
--------
_progres -rx (for UNIX)
prowin32.exe -rx -p _dict.p (for Windows)
There are limitations to this access though. You cannot load or dump data through the Administration. There are several ways to get data into your database though.
1) you can use pre-compiled 4GL code to load data (supplied by an AP).
2) you can use the bulkload and index rebuild utility.
3) you can use the binary dump / load and index rebuild utility.
4) you can use a progress client with compile capabilities (4GL or Provision).