Kbase P10883: How does my SQL 92 view appear from third party products
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
15/10/2008 |
|
Status: Verified
GOAL:
How does a SQL92 VIEW appear to a third party product.
GOAL:
Can a SQL92 VIEW be seen by a third party product?
FACT(s) (Environment):
Progress 9.x
UNIX
Windows
FIX:
When viewed through an SQL92 connection (ODBC or JDBC), a SQL92 VIEW appears as just like a table within a Progress database. Depending on the SQL92 client application you use, it may posses the capability of determining a SQL92 VIEW from a SQL92 table, as well as displaying the view (or table's) owner.