verify-index Command

The verify-index BASIC program verifies the integrity of one or all B-tree indexes in a specified file name.

Syntax

verify-index dict file.reference a.code {(options)}

verify-index dict file.reference attribute.defining.item {(options)}

verify-index dict file.reference * {(options)}

verify-index ?

Parameter(s)

a.code

Specifies the a processing code to be used in forming the keys to the index. The processing code must include an attribute number.

*

Designates all indexes.

?

Displays online help for this command.

options

a

Verifies all indexes in the account or system.

c

Compares the file to the index only.

e

Creates an error log. When this option is specified, the command prompts for the error log file and item.

f

Displays link and node-IDs during verification.

i

Displays item-IDs.

k

Verifies links and nodes.

l

Locks each data item as it is verified.

m

Suppresses all messages.

n

For Windows Only: Where n is an integer specifying a limit for the number of consecutive errors that can occur during index verification before moving on to the next index or file.

o

Reports missing item-IDs and locates items indexed in the wrong place. While using this option makes the process run slower, it increases the reliability and effectiveness of the process.

p

Directs report to system printer via the spooler.

r

Inhibits index recreation on link error.

s

Suppresses display of item counter.

v

Verifies that the data exists for the given indexes. This is used in the cases where the index contains pointers to item-IDs that have been deleted (this is not normal).

x

Suppresses automatic fix of bad indexes. This option produces a report only.

z

Stops processing after link and node verification.

With no options specified, the process examines each item in the file and verifies each of the indexes specified. A counter displays on the screen for monitoring the progress of the verify-index.

To verify a single index, the TCL casing set by the case command must match the casing of the index.

Example(s)

Verifies the index on attribute 1 of the entity file.

verify-index entity a1

Verifies all indexes in the entity file.

verify-index entity * (o

See Also

a (Algebraic) Processing Code

B-Tree

clear-index Command

create-index Command

delete-index Command

indexer Command

key Statement

nframe-index Command

vi.dump File