Kbase P18964: Can I access my 4GL-defined VIEWS from a SQL92 client connection?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/15/2008 |
|
Status: Verified
GOAL:
Can I access my 4GL-defined VIEWS from a SQL92 client connection?
FACT(s) (Environment):
Progress 9.x
UNIX
Windows
FIX:
VIEWS that are created using the Progress 4GL can not be accessed via an SQL92 client connection (i.e. Progress SQL Explorer or an ODBC client application).
However, Progress database tables created by the Progress Data Dictionary/Data Administration utilities can be accessed by a SQL92 client, provided they're reference using the PUB schema. EXAMPLE: select name from PUB.customer;