Consultor Eletrônico



Kbase P47454: How to find out which table resides in which extent ?
Autor   Progress Software Corporation - Progress
Acesso   Público
Publicação   8/14/2009
Status: Verified

GOAL:

How to find out which table resides in which extent ?

GOAL:

How to find out which table resides in which area ?

GOAL:

4GL Sample Code How to find out what area a table lives in?

GOAL:

4GL Sample Code How to find out what area a table resides in?

FACT(s) (Environment):

Progress 9.X
OpenEdge 10.0X
All Supported Operating Systems

FIX:

FOR EACH _file WHERE _file._file-num > 0 AND _file._file-num < 32767 NO-LOCK,
EACH _storageobject WHERE _Object-number = _File-Number NO-LOCK,
EACH _area OF _storageobject WHERE _storageobject._object-type = 1 NO-LOCK,
EACH _areaextent OF _area NO-LOCK:
DISP _file._file-name _storageobject._area-number _areaextent._extent-path FORMAT "X(40)".
END.