Progress
Version 9
Product Update Bulletin


DBTool Utility

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

The following error message is reported to a SQL application when the SQL _width for a column exceeds the Data Dictionary 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.
  3. Table H–1 describes the options available in the DBTool option menu.

    Table H–1: DBTool Option Menu 
    Option
    Description
    1
    Finds the maximum field size and reports them.
    2
    Finds the maximum field sizes and updates their widths.
    3
    Validates the schema versioning of the records after the records are updated by DBTool.
    4
    Validates the schema versioning before and after the records are updated by DBTool.
    5
    Validates db keys while scanning database blocks.
    9
    Enables or disables file logging.
    q
    Quits DBTool utility.


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095