xb_reindex - Man Page

xb_reindex -t myfile.DBF

xb_reindex -t myfile.DBF -n myindex.NDX

xb_reindex -h

xb_reindex -v

xb_reindex -c

xb_reindex -c

xb_reindex rebuilds NDX / MDX index files for a version 3 or 4 DBF file.  If this program encounters an error while rebuilding an index, it deletes the proble index (as opposed to leaving the index in an undefined state).

The Xbase64 library provides various utility programs and a set of C++ classes for application  programming for reading, writing and updating DBF database files, NDX and MDX index files and DBT memo files. Version 4.x.x has been tested for compatability with dBASE III (TM), dBASE IV (TM) and dBASE 5 (TM) version data files and  indices *.DBF (data), *.NDX (single tag index), *.MDX (multi tag index) and *.DBT (memo). In RDBMS parlance, each *.DBF file would be a table.

-h,  -?,  --help

display help information.

-v,  --version

display version information.

-t myfile.DBF

DBF file to reindex.

-n myindex.NDX

Optional NDX file to reindex.  If included, only the specified NDX file is rebuilt.  If not specified, all open indices are rebuilt.

-c

Run in DBase index compatibility mode.  For unique indices, this option allows for multiple records in the DBF table to have the same key value and only the first occurence is included in the index.  Also, deleted records are also maintained in the index.

-x

Run in XBase index mode.  Not compatible with -c mode.  This option does the following: 1) Do not allow records with duplicate key values to be added to a given table. 2) Remove deleted records from the index.   3) Recycles empty pages in MDX index files.

*.DBF *.DBT *.NDX *.MDX *.INF

Gary Kunkel <xdb-devel@lists.sourceforge.net>

xb_cfg_check(1), xb_clearix(1), xb_copydbf(1), xb_dbfutil(1), xb_deletall(1), xb_dumpdbt(1), xb_dumprecs(1), xb_execsql(1), xb_import(1), xb_pack(1), xb_tblinfo(1), xb_undelall(1)

<xdb-devel@lists.sourceforge.net>

xb_cfg_check(1), xb_clearix(1), xb_copydbf(1), xb_dbfutil(1), xb_deletall(1), xb_dumpdbt(1), xb_dumprecs(1), xb_execsql(1), xb_import(1), xb_pack(1), xb_tblinfo(1), xb_undelall(1).