Kbase P185077: Why is it not possible to create SQL-92 Views in the PUB schema?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
3/31/2011 |
|
Status: Unverified
GOAL:
Why is it not possible to create SQL-92 Views in the PUB schema?
GOAL:
Why is error 7879 generated when trying to create a SQL-92 View in the PUB schema?
GOAL:
Why is error " Incorrect view owner name on CREATE VIEW - cannot be PUB or _FOREIGN. (7879 ) " generated when trying to create a SQL-92 View in the PUB schema?
FACT(s) (Environment):
Progress 9.1x
OpenEdge 10.x
All Supported Operating Systems
FIX:
Database "entities" defined in the PUB schema are supposed to be inter-operable between the ABL and SQL-92. If an "entity" is in the PUB schema, then the ABL should be able to access and use it. However, the ABL does not understand OpenEdge SQL (SQL-92) Views.
Views are like virtual tables to SQL-92 that are structured and described in the schema (_File, _Fields ) as if they were tables but without a physical representation. If a SQL-92 View were defined in the PUB schema then the ABL would have many problems, such as trying to read the non-existent virtual table.