Kbase P10977: How to access VST's from SQL-92?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
11/7/2008 |
|
Status: Verified
GOAL:
How to access VST's from SQL-92?
GOAL:
How to access VST's from a SQL-92 client?
GOAL:
I want to access a Virtual System Table from SQL-92
GOAL:
Can a ODBC client access to Metaschema tables
GOAL:
Can a SQL-92 client access to Metaschema tables
FACT(s) (Environment):
All Supported Operating Systems
Progress 9.x
OpenEdge 10.x
FIX:
The VST's or Metaschema tables are 4GL tables.
Therefore, they are located in the schema PUB.
Since both VST or Metaschema table names are prefixed with "_" but "_"(underscore or underline) are reserved characters in SQL, to query it, you must remember to quote the table name as follows:
SELECT * FROM pub."_Connect";