I am trying to add a new relational index to a file and am getting a variety of error messages. When I try to add the index and get to the sort mode, I get a message saying this index already has a sort mode of ' ' and cannot be changed.

I also get the following message:

"The "file" table has relational indexes on it and the attached table '**' is not available or attached for updating control information."

Both files are attached with data.

Seems to me that my !index files are corrupted, but clearing them doesn't seem to help. This is Arev 3.0

Any suggestions. Thanks

Hi Laura!

Methinks you will have to go the specific DICT records (via the editor) and remove all traces of indexing on the affected fields. Then rebuild the remainder and then add the rest. If that doesn't work, remove ALL indexing and start over.

As my mentor, Albert Turner (the main SE on the IBM360 OS) used to say, the results are unpredicatable and usually bad. In this case, that would be true if you:

1) had ANY other indexing on either the source or the target field (such as BTREEs).

2) had a rightdex or quickdex on either file.

3) the length on either dict item was not AT LEAST as large as the largest single key that could be indexed.

4) the justification on either field was not EXACTLY compatible with the sort method you put on the relational index.

5) somehow, you may have copied one of those dictionary items to another file and it's still linking back without your knowledge.

6) one or both dictionary items are using a custom conversion that can't handle multiple values.

7) it's Monday and the boogieman is after us.

Hope this helps.

Larry Wilson

TARDIS Systems, Inc.

[email protected]

303-432-8630

View this thread on the forum...