Kbase P91819: What are the right metaschema tables to use in order to know in what area a table or an index is sto
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
8/18/2004 |
|
Status: Unverified
GOAL:
What are the right metaschema tables to use in order to know in what area a table or an index is stored?
GOAL:
What are the right metaschema tables to use since _index._ianum is obsolete (since Version 9)
FACT(s) (Environment):
Progress 9
FIX:
DEFINE VARIABLE cTitle AS CHARACTER NO-UNDO.
FIND _file NO-LOCK WHERE _file-name = "customer".
FIND _storage NO-LOCK WHERE _storageobject._object-type = 1
AND _storageobject._Object-number = _file._file-num.
FIND _area NO-LOCK WHERE _area._area-number = _storageobject._area-number.
cTitle = "Area used for table " + _file._file-name.
DISPLAY _area WITH FRAME a TITLE cTitle.
FIND _Index OF _file NO-LOCK WHERE _index-name = "custnum".
FIND _storage NO-LOCK WHERE _storageobject._object-type = 2
AND _storageobject._Object-number = _index._idx-num.
FIND _area NO-LOCK WHERE _area._area-number = _storageobject._area-number.
cTitle = "Area used for index " + _index._index-name + " of table " + _file-name.
DISPLAY _area WITH FRAME b TITLE cTitle.