Kbase 20404: Differences Between Views Created in SQL Explorer and 4GL Environment
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
23/03/2009 |
|
Status: Verified
GOAL:
What are the differences between Views created in SQL Explorer and 4GL Environment?
GOAL:
What are the differences between Views created in SQL Explorer and ABL Environment?
GOAL:
Why are ABL Views not visible to SQL users and vice versa?
GOAL:
Why are ABL Views not visible to SQL users?
GOAL:
Why are SQL Views not visible to ABL users?
FACT(s) (Environment):
Progress 9.x
OpenEdge 10.x
All Supported Operating Systems
FIX:
Progress Version 9.x introduced the SQL-92 engine. In order to maintain backward compatibility, Progress still supports the SQL-89 engine. However, SQL-92 is completely different from SQL-89. The two engines do not work with each other.
When a view is created in SQL Explorer, the SQL-92 engine is used. When a view is created in the Procedure Editor, the SQL-89 engine is used. Consequently, views that are created with Progress 4GL cannot be accessed through SQL Explorer or any ODBC client application, such as WinSQL, using the SQL-92 engine.