Kbase P3863: Getting error 7879 when creating a SQL-92 View
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
11/09/2002 |
|
Solution ID: P3863
FACT(s) (Environment):
Windows 2000
Windows NT 4.0
Progress 9.1C
Progress 9.1D
SYMPTOM(s):
Error 7879 when creating SQL-92 View
Incorrect view owner name on CREATE VIEW - cannot be PUB or _FOREIGN. (7879)
CAUSE:
SQL-92 View cannot be created under PUB schema.
Example: This statement will fail with error 7879:
create view pub.myview as (select * from pub.tbl)
FIX:
Create the View in a schema other than PUB.
Example: Assuming, you have a Schema named 'jmr', you can create your Schema using the following syntax:
create view jmr.myview as (select * from mytable);