Kbase 13967: How to find a table and index name for an index error 3850
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/05/1998 |
|
How to find a table and index name for an index error 3850
04/19/95
LJF
Some system errors actually point to a specific index that is
causing a problem for Progress. This index is usually referred to by
an ixnum. The following is an example of such an error.
SYSTEM ERROR: cxput return code = 1, ixnum = 20 (3850)
This piece of 4GL code will display the table name, index name, index
number, and whether the index is unique and if it is included in the
local schema.
Note: The index should always be in the local schema, so this field
should ALWAYS be "yes".
for each _index:
find first _file where recid(_file) = _file-recid.
find first _db where recid(_db) = _db-recid.
display _file-name format "x(18)"
_index-name format "x(18)"
_idx-num label "Number"
_Unique
_db-local label "Local".
end.
The output will look like this:
File-Name Index-Name Number Unique Local
------------------ ------------------ ------ ------ -----
_File _Db/File 1022 yes yes
_File _File-Name 1 no yes
_Field _Field-Name 3 yes yes
_Field _Field-Position 4 yes yes
Progress Software Technical Support Note # 13967