Phantom Relational Index (AREV Specific)
At 07 OCT 2005 02:34:27PM John King wrote:
I'm trying to filecopy an Arev file from the TCL window and I get the message:
Unable to move file "DICT.ICD9_TABLE" to volume "MEDCODES"
The "ICD9_TABLE" file has relational indexes on it and the related file "DICT.ICD06" is not available or attached for updating control information.
When I do a LISTINDEX on the file there is only one crossref field being indexed. If I remove the index it will let me copy the file but when the index gets readded and rebuilt I get the same message when copying. I checked all other indexes and didn't see any that had relational indexes pointing to any fields of the file I'm trying to copy. Anyone know why Arev is still thinking the file has relational indexes and is there any way to fix it? Thanks.
At 08 OCT 2005 06:27PM Richard Bright wrote:
How about deleting the %FIELDS% in DICT.Table. Then detach and reattach table. Finally Do a RLIst of some records in table to force the rebuild of the %FIELDS%.
Richard Bright
BrightIdeas New Zealand
At 10 OCT 2005 04:40PM R Johler wrote:
More of a workaround than a fix:
Write a short r/basic program to select the source table, readnext/read it's records and write them to the target table.
If both source and target will be named the same, setalias (setfile) using some other name to the target temporarily.