Obtaining File, Client, and Engine Version Number
You can use 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. Function Executor is a utility that simulates Btrieve client operations using the PSQL requesters.
Using Function Executor
Use Function Executor to determine the version of the client, local and remote engines.
►
To Determine the Engine Version using Function Executor
1
Access Function Executor from the operating system Start menu or Apps screen.
2
Do one of the following:
a.
Click View > Version from the File menu.
b.
Select the Btrieve Version Info toolbar button, as shown in Figure 8.
Figure 8 Selecting the Btrieve Version Info button
3
After choosing either of the Version options, a dialog box displays that indicates the version of the client requesters and the local engine. If a file is open when the Version option is selected, the remote engine version displays as well.
Figure 9 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. You cannot determine the version of a remote server engine with this tool.
Determining a File Version
You can determine the file version of a MicroKernel data file using the PSQL v12 utilities. On the Windows platform, use Control Center, Function Executor, DDF Builder, or Btrieve Maintenance. On any platform, use the BUTIL command-line utility. The following provides information on using a few of these methods.
Using the PSQL Control Center
You can use the PSQL Control Center to determine a file version.
►
To Determine the File Version of a Table Using PSQL Control Center
1
Access Control Center (PCC) from the operating system Start menu or Apps screen.
2
Find the database by expanding its name in the PSQL Explorer on the left.
3
Do one of the following:
a.
Click File > Properties from the File menu.
b.
Right-click a table name and select Properties as shown in Figure 10.
Figure 10 Obtaining a File Version with the PSQL Control Center
4
The table properties are displayed, which includes the file version of the underlying MicroKernel data file version.
Figure 11 Table Properties Page
Using Btrieve Maintenance
If you are unfamiliar with the command line, you can use the GUI-based Btrieve Maintenance tool.
►
To Determine the File Version of a Table Using Btrieve Maintenance Utility
1
Access Maintenance from the operating system Start menu or Apps screen.
2
From the File menu, click Options and select Show Information Editor.
The File Information Editor dialog box displays.
3
Click Load Information and the Select File dialog box displays.
4
Enter or browse for the file for which you need to determine the version.
The version displays in the upper right-hand corner of the dialog box.
Using Function Executor
The Function Executor utility can simulate Btrieve operations and can be used to determine the file version by performing a statistics report against the file.
►
To Determine the File Version of a Table Using Function Executor
1
Access Function Executor from the operating system Start menu or Apps screen.
2
From the File menu, click File then Open.
The Open Btrieve File dialog box displays.
3
Enter or browse for the file for which you need to determine the version.
4
With the file open in Function Executor, click View then File Statistics.
The File Statistics dialog box displays the file version in the top portion of the screen, as seen in Figure 12.
Figure 12 File Statistics in Function Executor
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 PSQL:
butil -stat dept.mkd
The BUTIL utility is documented in more detail in Advanced Operations Guide.