Obtaining File, Client, and Engine Version Number

---

You can use Pervasive.SQL 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

1. Load the Function Executor Utility.

   Click Start4Pervasive.SQL V84Other Utilities4Function Executor

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

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

    
   Figure 21-3    Selecting the Btrieve Version button

   

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

    
   Figure 21-4    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 the Pervasive Control Center or Function Executor on Windows platforms, or using the BUTIL command-line utility on any platform:

• Using the Pervasive Control Center to select the properties of a table.
• 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 the Pervasive Control Center

You can use the Pervasive Control Center to perform this task.

   To Determine the File Version of a Table Using Pervasive Control Center

1. Click Start4Programs4Pervasive.SQL V84Control Center
2. Find the database by expanding its name in the Control Center namespace on the left.
3. Right-click on a table name and select Properties as shown in Figure 21-5.

    
   Figure 21-5    Obtaining a File Version with the Pervasive Control Center

   

4. The table properties are displayed, which includes the file version of the underlying MicroKernel data file.

    
   Figure 21-6    Table Properties Page

   

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:

1. Open (0)
2. 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.SQL:

butil -stat dept.mkd 

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