Btrieve Butil

RESET - Resets user resources
CREATE - Creates Btrieve File
STAT - Display file Statistics
COPY - Copy records from one Btrieve file to another
DROP - Removes supplemental index
INDEX - Create external index
EXTEND - Extend file across volumes
LOAD - Load sequntial data into file
RECOVER - Extract sequential records from damaged file
SAVE - Extract sequential file
SINDEX - Creates supplementary index
STOP - Removes resident Btrieve from memory
VER - Displays current version

RESET - Resets user resources

The RESET command using the following format:

BUTIL -RESET [<station name>|<user >|<process id>]

The Reset utility performs a Btrieve reset operation to release the resources

It releases all locks, aborts any pending transactions, and closes any open files for the station.

CREATE - Creates Btrieve File

To run CREATE use this format:

BUTIL -CREATE <FILE-NAME> <DESCRIPTION-FILE>

The CREATE utility generates an empty Btrieve file with the characteristics you specify. Before you have to provide it with some specific instructions in a description file.

See:

• Sample description file for Butil -Create
• Btrieve Key types
• Description File parameters

STAT - Display file Statistics

To run STAT using the following format:

BUTIL -STAT <FILE-NAME> [-O<OWNER>]

STAT reports the defined characteristics of a Btrieve file and statistics about its contents. Use STAT to determine all parameters specified for a file with the CREATE utility, and provides information on the volume of keys and records in the file and the name of the file's extensions.

COPY - Copy records from one Btrieve file to another

To run COPY using the following format:

BUTIL -COPY <INPUT-FILE><OUTPUT-FILE>[-O <OWNER1> [-O<OWNER2>]]

The copy utility copies the contents of one Btrieve file to another.

To do this first create a new file with the new characteristic. then use the COPY command to transfer the data records to the new file.

DROP - Removes supplemental index

The command format for the DROP utility is as follows:

BUTIL -DROP <Btrieve file><Key number>[-O<owner>]

Use the BUTIL -DROP utility to remove a supplemental index from a Btrieve file.

INDEX - Create external index

To build an external index using the format below:

BUTIL -INDEX <BTRIEVE-FILE> <INDEX-FILE> <DESCRIPTION-FILE> [-O<OWNER>]

Allows to index a Btrieve file based on a field in a record that you had not previously specified as key. The records in the new file consiste only of the 4-byte direct adress of each record in the original Btrieve file followed by the value on which you wish to sort.

EXTEND - Extend file across volumes

To extend a file across two volumes, enter your EXTEND command following the format shown below:

BUTIL -EXTEND <BTRIEVE-FILE> <EXTENSION-FILE> [-O<OWNER>]

Enables to create files which extend across two logical disk drives. When you create a Btrieve file with CREATE you can define the file only for a single volume.

LOAD - Load sequential data into file

To start LOAD using the following format:

BUTIL -LOAD <INPUT-FILE> <BTRIEVE-FILE> [-O<OWNER>]

LOAD allows to insert records from a sequential file into a Btrieve file.

It expects each record in the load file to begin with the length of the record in ASCII a one character separator, the record which should be the exact length given, and a carriage return /line feed.

RECOVER - Extract sequential records from damaged file

To retrieve the data from a damaged Btrieve file, enter your command using the following format:

BUTIL -RECOVER <BTRIEVE-FILE> <OUTPUT-FILE>[-O<OWNER>]

Allows to recover data from a damaged Btrieve file.

SAVE - Extract sequential file

To run SAVE enter your command in the following format:

BUTIL -SAVE <BTRIEVE-FILE> <OUTPUT-FILE> [<INDEX(Y/N)> <INDEX-FILE>| <KEY NUMBER>] [-O<OWNER>]

Lets you retrieve the records from a Btrieve file and store them in a sequential file. It is the exact inverse of LOAD.

SINDEX - Creates supplementary index

The command format is as follows:

BUTIL -SINDEX <Btrieve file> <description> [-O<OWNER>]

Creates a supplemental index for an existing Btrieve file.

STOP - Removes resident Btrieve from memory

To run STOP enter your command as follows:

BUTIL -STOP

STOP removes the Btrieve Record Manager from memory and returns Btrieve allocated memory to the operating system.

VER - Displays current version

To run VER enter your command as follows:

BUTIL -VER

This utility reports the version of the Btrieve record manager that is loaded at the workstation.