Kbase P126114: Error (247) running CREATE VIEW SQL statement
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
16/10/2008 |
|
Status: Unverified
FACT(s) (Environment):
Progress 7.x
Progress 8.x
Progress 9.x
OpenEdge 10.x
All Supported Operating Systems
SYMPTOM(s):
Error (247) running CREATE VIEW SQL statement
** Unable to understand after -- "FROM customer". (247)
** Could not understand line 1. (198)
Running CREATE VIEW test as SELECT * FROM customer UNION SELECT * FROM customer
SQL statement is being typed in the Procedure Editor
CAUSE:
Non supported SQL-89 statement is being used.
FIX:
The SQL-89 Guide and Reference Manual states that: "you cannot use a UNION statement within the CREATE VIEW statement. You can use only a simple SELECT statement.". SQL-92 should be used instead.