Kbase P18271: Is it possible to access an SQL92 VIEW via SQL89 ?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
15/10/2008 |
|
Status: Verified
GOAL:
Is it possible to access an SQL92 VIEW via SQL89 ?
GOAL:
Is it possible to see a SQL92 VIEW using a SQL89 client connection ?
FACT(s) (Environment):
Progress 9.x
UNIX
Windows
FIX:
NO. A SQL92 VIEW is stored within the SQL92 engine. An SQL89 client connection is established to the 4GL engine. Thus, an SQL VIEW created using a SQL92 client can not be seen (or accessed) by a SQL89 client connection.