Deletetable not working (AREV Specific)
At 18 APR 2003 10:59:56AM Kauko Laurinolli wrote:
Deletetable could't delete one table with link list errors.
I fixed it by renaming it to MYTABLE_BAD and and copied dict and data to MYTABLE and re-indexed.
Now it works but I can't do: deletetable MYTABLE_BAD?
How can I do that and how do I delete !MYTABLE_BAD table?
At 18 APR 2003 12:04PM Richard Hunt wrote:
Kauko,
Try "CLEARTABLE" first, then do the "DELETETABLE". "CLEARTABLE" will handle all errors.
Understand perfectly that using "CLEARTABLE" will clear the table and it is NOT reversable!
At 18 APR 2003 12:07PM Don Miller - C3 Inc. wrote:
Well .. you can do the following:
1. Edit the REVMEDIA to remove the entries (make note of its REV number).
2. Go to DOS and delete the associated REV**.LK/OV.
FWIW, there is a utility that will let you do this as well as editing the REVMEDIA to remove or change other things. If you need it, e-mail me at:
DCMill1999@aol.com
Happy Easter or Passover, or weekend, if you prefer.
Don M.
At 18 APR 2003 04:06PM Kauko Laurinolli wrote:
Tried CLEARTABLE but DELETETABLE still doesn't work.
At 18 APR 2003 05:42PM Victor Engel wrote:
It looks like maybe indexing is giving you trouble. Try removing indexing from the table using the menus. That should remove your ! file. If it doesn't, then edit the REVMEDIA entry for the file and delete SI.MFS from the MFS line. You will have to be in SYSPROG or SETALIAS to the SYSPROG account to do this. If you do the manual method, reattach the volume. Now, delete the !file and then the data file.
It's possible that maybe you have an orphaned entry in the REVMEDIA file, do a LISTVOLUME of the volume containing the file. Note the entries for the data, dictionary, and index files. Check to see if the corresponding DOS files actually exist. If not, you may have to manually delete the REVMEDIA entries. If you manually delete the REVMEDIA entries and the files (LK and/or OV) do exist, you will have to delete them manually as well.
At 19 APR 2003 09:12AM Kauko Laurinolli wrote:
Removing index will not remove !FILE.
Everyone wants to help amd recommends editing REVMEDIA but nowhere I can find instructions how to edit that gibberish?
At 19 APR 2003 10:36AM Richard Hunt wrote:
Kauko,
Be sure that all users are logged out.
This is how to edit the "REVMEDIA" table. Get to a command window. Normally an "F5" will open a command window.
Use the "SETALIAS" command as follows…
SETALIAS LOCATION APPLICATION TABLENAME ALIASNAME
Example… SETALIAS TABLES TEST ACCOUNTS PTR
You can find the location by typing this command in…
LIST SYSTABLES TABLENAME VOLUME
TABLENAME being the table you want to look at.
Now once you have done that, you can simply EDIT the REVMEDIA table using the command…
EDIT ALIASNAME FILENAME*APPLICATION
ALIAS being the name you used in the "SETALIAS" command.
Now, be very careful here. If you make a mistake, other problems will happen. They might become serious problems!!!
If you want to delete the table then note the "DOS" file name that is in field 1 (REV00000). After noting the DOS file name, delete this item from this table. Then you must delete the table from your windows system (REV00000.LK and REV00000.OV). You can use windows explorer or the DOS DEL command.
You can repeat the above paragraph for the index table (!REV00000) too.
Lastly, logout then log back in. That table should be gone.
At 21 APR 2003 03:20PM Victor Engel wrote:
The REVMEDIA file is just another Arev file, but it is not attached as a file you can see by default. You must explicitly attach it.
The most straightforward way to do this is as follows:
Log on to the SYSPROG account.
From a TCL prompt, ATTACHTABLE volume REVMEDIA, where volume is the name of the volume your file is on.
Now REVMEDIA is attached as a file just like any Arev file. The key to the file is filename*accountname. In the case of your problem, I would suggest these steps:
From your normal application, edit all dictionary items (using DICT) to make sure there is no index information in any of the fields. Indexing information is kept in multiple places, including individual dictionary records, the REVMEDIA file, and the ! file. If you remove the indexing information from one of these and not the others, there could be problems, so make sure the DICT window doesn't show any index information for any of the dictionary items as a first step.
EDIT REVMEDIA filename*accountname and remove SI.MFS if present. If there is information below SI.MFS, you don't want to shift it up, so just use the delete key to remove SI.MFS. F9 to save.
Now log back to your regular account. If the !filename file is available, it should be attached but no longer associated with the data file as its index. You can delete the !filename file now.
