Obtaining File, Client, and Engine Version Number

You can use Pervasive PSQL utilities to verify that the client and engines have the version number you expect, or to check the version of a particular file.

Determining Client and Engine Version

You can check the engine and client versions using Function Executor on Windows platforms or using the BUTIL command-line utility on all platforms:

Using Function Executor

From the Pervasive program on the Start menu, click Function Executor in the list for Other Utilities.

Function Executor is a utility that simulates Btrieve client operations using the Pervasive PSQL requesters.

Select the Btrieve Version Info button, which appears as a clock icon. The correct button is shown in Figure 19-2.

Figure 19-2 Selecting the Btrieve Version button

After choosing the Btrieve Version Info button, a dialog displays that indicates the version of the client requesters and the engine.

Figure 19-3 Btrieve Version Info Display

Using the BUTIL Utility

From a command prompt, enter the following:

BUTIL -VER

The requester and engine versions are then displayed.

Determining a File Version

You can determine the file version of a MicroKernel data file using Function Executor on Windows platforms, or using the BUTIL command-line utility on any platform:

Using Function Executor to open and then query the version of a file.

Using BUTIL command-line utility to query the statistics of the file.

Using Function Executor

The Function Executor utility can simulate Btrieve operations and can be used to determine the file version by performing the following operations:

Open (0)

Version (26)

The Function Executor utility is documented in more detail in Advanced Operations Guide.

Using BUTIL command-line utility

Use the -stat parameter of BUTIL to query the file statistics, which includes information about:

File version

Pages

Records

Keys

Type the following at a command prompt:

butil -stat <filename>

For example, to query the statistics of the file DEPT.MKD of the DEMODATA database included with Pervasive PSQL:

butil -stat dept.mkd

The BUTIL utility (available on Windows, NetWare, and Linux) is documented in more detail in Advanced Operations Guide.