Kbase 20139: How to a Relate Table Name with it's Area and File/Table Number
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
02/09/2008 |
|
Status: Verified
GOAL:
How to a Relate Table Name with it's Area
GOAL:
How can I determine a table name via a table number?
GOAL:
How to identify a table name by a table number?
GOAL:
How to find the file number associated with a table?
GOAL:
How to find the table name based on the table number reported from promon
FACT(s) (Environment):
Progress 9.x
OpenEdge 10.x
FIX:
Tables are stored in logical areas for a number of reasons including load balancing. In order to programmatically find out what area a given table is in, go through the _Storage Object file.
This file contains fields that reference the _area-number and the _object-number that correlate to the _file-number field in the _file table.
Run the following code to get a list of areas and their associated tables:
FOR EACH _storageObject:
FIND FIRST _area WHERE _area._area-number =
_storageObject._area-number NO-ERROR.
FIND FIRST _file WHERE _file._file-number =
_storageObject._object-number NO-ERROR.
IF AVAILABLE _file THEN
DISPLAY _area._area-name _file._file-name.
END.