Trying to create a btree index on a table using the following:
run create_index 1,'WINWORD','LOCATION',0,1
results in the following:
FS100: Record "DICT.!WINWORD*PS" does not exist.
List_Index shows the index as having been created but both the index and the table are unusable. Removing the index makes the table usable again.
This is happening on a few, but not all, tables.
Could anyone explain why it is looking for a "DICT.!tablename" file and suggest a solution.
Thanks
The easy answer is that the Indexing process looks for a corresponding Dictionary item. It sets a flag in Field 6 of that element (1 for B-Tree). To the best of my knowledge, there is no DICT.!filename associated with indexing. Maybe I'm not understanding your question, though.
Don M.