Difference between revisions of "COPY INDEXES"
Yvonne.milne (Talk | contribs) |
|||
| (5 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
==Purpose== | ==Purpose== | ||
Copy single indexes to a multiple index file | Copy single indexes to a multiple index file | ||
| − | |||
==Syntax== | ==Syntax== | ||
COPY INDEXES <.ndx filelist> [TO <.dbx filename>] | COPY INDEXES <.ndx filelist> [TO <.dbx filename>] | ||
| − | |||
==See Also== | ==See Also== | ||
| − | [[COPY STRUCTURE | + | [[COPY STRUCTURE]], [[DELETE TAG]], [[INDEX]], [[SET INDEX]], [[TAG()]], [[TAGCOUNT()]], [[TAGNO()]], [[USE]] |
| − | + | ||
==Description== | ==Description== | ||
| Line 16: | Line 13: | ||
====TO <.dbx filename>==== | ====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. | 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== | ==Example== | ||
| Line 26: | Line 22: | ||
| − | |||
| − | |||
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:Commands]] | [[Category:Commands]] | ||
| − | [[Category: | + | [[Category:NoSQL Commands]] |
| − | + | ||
Latest revision as of 06:17, 30 September 2016
Purpose
Copy single indexes to a multiple index file
Syntax
COPY INDEXES <.ndx filelist> [TO <.dbx filename>]
See Also
COPY STRUCTURE, DELETE TAG, INDEX, 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
