KT.FIXINDEXPATH {file.name | ALL | * ...}
If you move or copy a file at the operating system level, this command can be used to change the file header information to point to the new location for the secondary indexes. This command will only process files that are local to the current account.
The command only applies to systems running the UniVerse RDBMS.
Options
| file.name | Enter the name of the UniVerse file to process. Multiple files may be specified on the command line separated by the space character. If the keyword * or ALL is specified, all local files in the account will be processed. If a select list is active, only those files will be processed. |
In this example, a single file was specified on the command line.
>KT.FIXINDEXPATH CUSTOMER
CUSTOMER SKIPPED - File is OK
Files Read: 1 Fixed: 0 Errors: 0
In this example, several files are specified on the command line. The CUSTOMER and SALESREP files are local to this account and the file header information is correct. The PARTS file is local to this account and the file header information was corrected. The MFILE is local to this account but is the master distributed file pointer and is not processed. The SECURITY file is not local to the account so the file is not processed. The word GT is not a file (it's a keyword) and it is not processed.
>KT.FIXINDEXPATH CUSTOMER PARTS SALESREP MFILE GT SECURITY
CUSTOMER SKIPPED - File is OK
PARTS File header block updated.
SALESREP SKIPPED - File is OK
MFILE SKIPPED - File is master distributed file pointer
SECURITY SKIPPED - File is not local
Files Read: 4 Fixed: 0 Errors: 0