tcl.verify-index Verb: Access/TCL

tcl.verify-index

Command tcl.verify-index Verb: Access/TCL
Applicable release versions: AP, AP 6.1
Category TCL (746)
Description verifies the integrity of one or all b-tree indices in a given filename.

"a.code" specifies the "a (algebraic)" processing code to be used in forming the keys to the index. The processing code must include an attribute number.

The "*" (asterisk) designates all indices.

A "?" displays on-line help for this command.

With no options specified, the process examines each item in the file and verifies each of the indicies specified. A counter displays on the screen for monitoring the progress of the "verify-index".
Syntax verify-index file.reference a.code {(options)}
verify-index file.reference * {(options)}
verify-index ?
Options c Compares the file to the index only.

e Creates an error log. When this option is specified, the command will prompt for the error log file and item. (Only available on AP 6.1.0 and above.)

f Displays link and node-id's during verification.

i Displays item-id's.

k Verifies links and nodes.

l Locks each data item as it is verified.

m Suppresses all messages.

o Reports missing item-id's 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 indices. This is used in the case where the index contains pointers to item-id's which have been deleted. This is not normal.

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

z Stops processing after link and node verification.
Example
verify-index entity a1
Verifies the index on attribute 1 (one) of the "entity" file.

verify-index entity * (o
Validates all indexes in the "entity" file.
Purpose
Related tcl.create-index
tcl.nframe-index
b-tree
filename.vi.dump
tcl.clear-index
tcl.indexer
pc.index.fdi
pc.a
tcl.delete-index
basic.key