Kbase 21626: Why Is the SQL Table Not Viewable in the Data Dictionary?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
8/20/2009 |
|
Status: Verified
GOAL:
Why is a SQL-92 table not viewable from the Data Dictionary?
GOAL:
Why cann't I see SQL-92 tables in dictionary?
GOAL:
Can I view a SQL-92 Table via ABL?
FACT(s) (Environment):
All Supported Operating Systems
OpenEdge 10.x
Progress 9.x
FIX:
The Progress 4GL can only access the tables that are defined in the PUB schema. Therefore, if the SQL table that is being created is part of a schema other than PUB, then the Data Dictionary Tool will not be able to display that table.
In order to have the SQL table that's being created displayed on the Progress Data Dictionary screen, explicitly specify PUB as the owner name when issuing the CREATE TABLE SQL Statement. For example:
CREATE TABLE pub.contact (name, phone, company)
AS SELECT contact, phone, name FROM pub.customer;