Kbase P13650: How to view the Progress 9.x virtual system tables?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
30/12/2004 |
|
Status: Unverified
GOAL:
How to identify the application user-defined tables?
GOAL:
How to view the Progress 9.x virtual system tables?
GOAL:
How to view the Progress 9.x metaschema tables?
GOAL:
How to view the Progress Database system tables?
FACT(s) (Environment):
Progress 9.x
FIX:
The Version 9.x metaschema can be viewed as two parts:
- The Progress, or 4GL that the Progress client accesses.
- The SQL-92 part that is accessed by the SQL-92 engine (ODBC and JDBC access).
The 4GL part still has metaschema tables starting with '_'. They are
all numbered less than 0. In the past, this provided two search criteria for identifying the application tables:
FOR EACH _file WHERE _file._file-name < '_' :
FOR EACH _file WHERE _file._file-number > 0 :
With the Version 9.x database, there are some system tables that do not begin with '_' and have a file number > 0.
There is a new field in the Version 9.x _file table called _owner. This can be used to identify the tables that belong to the 4GL part of the database.
All 4GL tables are owned by "PUB". Thus, the criteria for finding the user-defined tables in the database are:
- Tables where _file._owner = "PUB"
- Tables where the file-number is > 0
FOR EACH _file
WHERE _file._owner = "PUB"
AND
_file._file-number > 0: