COPY INDEXES

From Recital Documentation Wiki
Revision as of 13:22, 23 October 2009 by Helengeorge (Talk | contribs)

Jump to: navigation, search


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