Kbase P69247: ? values displayed for _ianum field after conv89
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
06/04/2004 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.1D
FACT(s) (Environment):
Progress 8.3E
SYMPTOM(s):
? values displayed for _ianum field after conv89
CHANGE:
Database converted from v8 to v9 using conv89
CAUSE:
The _File._ianum field contains the storage area number associated with a table; it is to help Progress create the table in the appropriate storage area. After the table has been created _ianum is then not used again.
For databases converted using conv89, _ianum contains "?" values for those tables that were present when the database converted. Even if tables are moved out of the schema area, the "?" value is still reported. This is expected behaviour.
FIX:
Use _area-number instead of _ianum, e.g.
FOR EACH _storageobject WHERE _object-type = 1.
FIND _file WHERE _file-num = _object-number.
DISPLAY _file-name _area-number.
END.