Home > MultiValue Central > Online D3 Reference > Restore Processor > pc.index.local

pc.index.local

Processing Code/Restore Processor, Releases: AP

Defines local b-tree index.

Description

indicates that an index exists for the current attribute.
It must be defined in the attribute-defining item which corresponds to a 'local' b-tree index previously created with a 'create-index' command.

Utilizing Advanced Pick's b-tree indices consists of a two step process:

The first step is the creation of the index. The 'create-index' establishes a new B-tree index.

The second step is defining the attribute index correlative on the input-conversion attribute of the dictionary. There may be one (either 'local' or 'remote') or two (one 'local' and one 'remote') indexes defined in any given attribute-defining item.

To access data in other files, see 'index, remote'.

When editing data in the attribute using the Update processor, the operator can 'cruise' forward and backward through the items in the file. <ctrl>+d accesses the previous item based on the index; <ctrl>+f accesses the next item. A bell signifies the beginning or end of the index.

There can be more than one index created on any given attribute. If more than 1 index exists, the desired format must be specified.

Example

Create an index on attribute 1:
create-index filename a1
The 'i' processing code must be added to the input-conversion
attribute of the corresponding attribute-defining item before the index may be
used by the Update processor.

Create an index consisting of attribute 1 concatenated with attribute 2.
create-index filename a1:2

See Also

Command Name Type Description
tcl.create-index Verb: Access Creates new b-tree index.
cruising Definition Searches local and/or remote indexes.
tcl.ud Verb: Access Updates dictionary of given file.
pc.index.fdi Processing Code Maintains the root.fid of the index.
output-conversion Attribute Defining Item References attribute 14 of a dictionary.
processing.codes Definition Overview of processing codes.
index.local Processing Code See 'i (index, local)'.
b-tree Definition Balanced-tree index.
up.input-conversion.adi Processing Code Processing codes available from UP after input.
double.clutching Definition Searches through remote file.
pc.a Processing Code Defines algebraic processing expression.
pc.index.remote Processing Code Defines remote b-tree index.
pc Introductory
up.macro Definition Identifies the default attribute-defining items used for input and output processing of the item.

User Comments

What do you think?

Share your experience or ask a question by using the form below.

Login to leave your comments.