Kbase P152240: How to reference unique table name in both Progress and foreign databases?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
9/25/2009 |
|
Status: Verified
GOAL:
How to reference unique table name in both Progress and foreign databases?
GOAL:
How do I reference tables with the same name in both Oracle and Progress databases without getting an error message?
FACT(s) (Environment):
Progress 7.x
Progress 8.x
Progress 9.x
OpenEdge 10.x
FIX:
When connecting to a foreign database, one needs to connect to a schema holder. There is a logical name defined in the schema holder. The server type (that is, the foreign database type) for this logical schema image is Oracle, MS SQL or ODBC.
Assuming your logical name is "orcl", reference the Oracle table as orcl.customer so it will not conflict with a Progress table called customer.
For example, when connecting to both Progress and Oracle, if both have table named "customer" do something like this:
find first orcle.customer where custnum=10
....
find first customer where custnum=10
.......