Difference between revisions of "COPY INDEXES"
Yvonnemilne (Talk | contribs) |
Yvonnemilne (Talk | contribs) |
||
| Line 1: | Line 1: | ||
| − | |||
| − | |||
| − | |||
==Class== | ==Class== | ||
Indexing | Indexing | ||
| Line 11: | Line 8: | ||
==Syntax== | ==Syntax== | ||
| − | COPY INDEXES <.ndx filelist> | + | COPY INDEXES <.ndx filelist> [TO <.dbx filename>] |
| − | + | ||
| − | [TO <.dbx filename>] | + | |
==See Also== | ==See Also== | ||
| − | [[ | + | [[COPY STRUCTURE]], [[CREATE]], [[DELETE TAG]], [[INDEX]], [[MODIFY STRUCTURE]], [[SET INDEX]], [[TAG()]], [[TAGCOUNT()]], [[TAGNO()]], [[USE]] |
Revision as of 09:27, 28 April 2009
Contents
Class
Indexing
Purpose
Copy single indexes to a multiple index file
Syntax
COPY INDEXES <.ndx filelist> [TO <.dbx filename>]
See Also
COPY STRUCTURE, CREATE, DELETE TAG, INDEX, MODIFY STRUCTURE, SET INDEX, TAG(), TAGCOUNT(), TAGNO(), USE
Description
The COPY INDEXES command creates a multiple index by copying single index files to one file. This command is useful for converting .ndx files to .dbx files. This command requires the indexes to be active before the copy can be performed. Use SET INDEX TO <.ndx file> to open a single index file. By default the index tag or tags are created in the production index. If no production index exists, then a new one is created.
TO <.dbx filename>
If the TO <.dbx filename> clause is used, the tag or tags are created in the specified .dbx file. If the .dbx file does not exist, it will be created.
Example
use accounts set index to ordno, invno copy indexes ordno, invno
Products
Recital Database Server, Recital Mirage Server, Recital Terminal Developer
