Kbase P39660: How to run the same compiled (.r) procedure against differen
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
25/11/2003 |
|
Status: Unverified
GOAL:
How to run the same compiled (.r) procedure against different databases which have the same schema information
FIX:
Start a session connected to "-db db1 -ld mydb" and compile .p code against "mydb"
When running the procedure start the session connected to both databases "-db d1 -ld d1 -db d2 -ld d2" and create "mydb" alias for the database to run the code against before calling the compiled code (.r)
i.e.
CREATE ALIAS mydb FOR DATABASE d1 .
RUN .r .
CREATE ALIAS mydb FOR DATABASE d2 .
RUN .r .