Kbase 18896: How To Change The Logical db Name with DataServer Schema Holder?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
3/13/2008 |
|
Status: Verified
GOAL:
How to change the logical database name (-ld) after creating schema holder?
GOAL:
How to change the -ld (logical name) of my foreign data source?
FACT(s) (Environment):
DataServers
FIX:
When connecting to a Progress database, Progress will automatically assign the database a logical database name. This default name is the same name as the physical database name. The purpose of the logical database name is to assist in resolving database references and it will store the logical name in the compiled r-code of any procedures that you compile with that reference. Using a logical
database name provides you an opportunity to run your application (without having to recompile) after having changed the physical name of your database.
In creating a Schema Holder a -ld (logical name) must be specified. This name will be used when connecting to foreign database.
There are two ways to change the (-ld) logical database name within the schema holder:
1. First Option:
a. Connect to schema holder
b. Go to the data dictionary and select working database.
c. Select the logical name of the foreign database
d. Once attempting to connect, question will be prompted:
"Database (logical-name) is not connected. Would you like to connect?"
e. Select, "no". Once no has been selected, go to the DataServer option and select DataServer utilities, Edit Connection Information. Change the logical database name for your foreign database and save the change.
2. Second option:
a. While connected to the schema holder, dump the .df from the schema holder using Admin tool on the Data Administration
b. Edit the .df to change the new logical name and save the changes.
c. At this point, you can either delete the schema holder image from DataServer menu > DataServer utilities > Delete schema holder from Data Administration and load the modified .df
or, create an empty database, and load the modified .df into the schema holder using Admin > Load Data and Definitions > Data Definitions (.df file).