CONSTRUCT
The CONSTRUCT command builds the internal indexes for keyed fields. Keyed
fields are used by FIND and MATCH.
Notation standards
Options
Answers
Syntax:
CONSTRUCT/options
[tablename] [fieldname]
Options:
X -Suppress
the command response
Y -Do
not alter the command answer cells
Answers:
Ctl.Ans1 =Zero
Ctl.Ans2 =Zero
Ctl.Ans3 =Zero
Notes:
If you have a table with just a couple of hundred records in it, you do not
need to bother declaring local fields (fields that are known only in that
table, i.e., not global) as keys, as FIND and MATCH will work with non-key
fields also. And with just a couple of hundred records, they will be fast
enough. But for global keys and tables with a larger population of records, you
do want to declare fields that will be used in queries as keys, and build
indexes for them so that FIND and MATCH will respond quickly.
After you have LOADed new data into your database, you must use either
CONSTRUCT or STRUCTURE to build the indexes for fields declared as keys.
Unless you have some very specific needs, you almost never need to use the
CONSTRUCT command because the STRUCTURE command will do the same thing, and it
will do it much faster. See the STRUCTURE command
description.
Examples
CONSTRUCT
builds key index structure for every keyed field in the data base. The
STRUCTURE command will do this job much faster.
CONSTRUCT
CUSTOMERS
builds key index structure for all the keyed fields in the CUSTOMERS table. The
STRUCTURE command has no table-specific capability so it does not do this.
CONSTRUCT
CUST#
builds key index structure for the CUST# field in every table where it is a
key. The STRUCTURE command will do this job much faster.
CONSTRUCT
CUSTOMERS CUST#
builds key index structure for the CUST# field just in the CUSTOMERS table. The
STRUCTURE command does not do this because it has no ability to be table
specific.
Copyright © 2019 , WhamTech, Inc. All rights reserved. This
document is provided for information purposes only and the contents hereof are
subject to change without notice. Names may be
trademarks of their respective owners.