Kbase P37218: How can I access a SQL92 VIEW's definition?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/15/2008 |
|
Status: Unverified
GOAL:
How can I access a SQL92 VIEW's definition?
GOAL:
How can I access a SQL92 VIEW's definition using 4GL?
GOAL:
How can I access a SQL92 VIEW's definition using SQL?
FACT(s) (Environment):
Progress 9.x
UNIX
Windows
FIX:
From the Progress Procedure Editor, use the following 4GL code segment:
FOR EACH _sysviews WHERE _Viewname = "cust_view" NO-LOCK :
DISPLAY _sysviews with 1 col.
END.
From a SQL92 client connection (i.e. Progress SQL Explorer or an ODBC client application) using the following SQL92 syntax:
SELECT * FROM PUB."_sysviews" WHERE "_Viewname" = 'cust_view';