The DBTool utility allows users to identify when the size of column data in the database exceeds the Data Dictionary definition and therefore the SQLWidth value. The DBTool utility addresses this situation because it allows for the fast updating of Data Dictionary SQLWidth definitions.

The following error message is reported to a SQL application when the SQLWidth for a column exceeds the Data Dictionary SQLWidth definition:

Column column in table table has value exceeding its max length or precision (7864)

The syntax for DBTool is:

Syntax 

dbtool dbname

To access DBTool from the command line:

  1. Type dbtool and the database name and press Enter.
    The DBTool option menu appears:


  2. Select an option from the menu and press Enter.

The following table describes the options available in the DBTool option menu.

Table 1. DBTool option menu
Option Description
1 Finds the maximum field sizes and reports them.
2 Finds the maximum field sizes and updates their widths.
3 Compares the physical storage of the record to the schema definition and reports discrepancies.
4 Validates the schema versioning before and after the records are updated in DBTool.
5 Validates db keys while scanning database blocks.
6 Scans records for indications of possible corruption.
7 Checks for inconsistencies in the database schema. This option identifies errors in schema records for word indexes. If an error is detected, this option reports the index number and recommends rebuilding that index.
9 Enables or disables file logging.
Q Quits the DBTool utility.

For more information on the DBTool utility, see Manage OpenEdge Databases.