DbMgr
DB Manager is the utility program for maintaining your Comet Files Data Dictionary. The dictionary is used by the Reporter and the CmtHelpD lookup subprogram.

Using DB Manager

There are several ways to start the DB Manager:

  1. From The Comet Reporter, click on the "DbMgr" button.
  2. From DataExpress, select the "Administrative Tools" tab, then click the DbMgr button.
  3. From the READY prompt, type DBMGR and press Enter.
  4. From the Comet Utility Programs menu, select number 36.

The DB Manager screen is displayed. Notice the options buttons on the left and the tabs on the right.

The following options are available:

  • Add a New Definition
  • Delete Definition
  • Clone Definition
  • Apply
  • Excel View
  • XML
  • Close

The following tabs are available:

  • File tab
  • Fields tab
  • Links tab
  • Options tab
  • Utilities tab

Adding or Editing a Definition

To add a new data dictionary definition, click on the "Add New Definition" button. A dialog is displayed prompting for the following items:

  1. Definition name

    Enter a descriptive name for the data dictionary definition (up to 32 characters). Example: Cust.History

  2. Data file name

    Enter the actual file name.

  3. Directory

    Choose the directory where the data file is located.

Click the "OK" button.

Click the "Apply" button at any time to save the current definition.

On the "File" tab:

  1. Enter a descriptive title for the file definition.

  2. Verify that the actual file name and directory are correct.

  3. Select the type of file: Keyed, Sequential, or Contiguous

  4. Enter the row size (number of characters in each record of the file).

  5. If the file is a keyed file, enter the key size.

  6. Optional: If the file is a keyed file, enter the name of the keyfield. This step presumes that fields have already been defined (see "Fields" tab).

  7. If the file is an image file, check the "Image File" box.

On the "Fields" tab:

  1. To add a new field, click on the "Add a Field" button. A dialog is displayed prompting for information about the field:

    a. Enter a name for the field (up to 32 characters).

    b. Choose the field type: Numeric or String

    c. Choose the field positioning option.

    d. Enter the field size.

    e. If the field is numeric, enter the number of decimal places.

    f. Enter the field's position in the record.

    g. If the field is a calculation, check the "Calculation" box. After clicking the "OK" button, enter the calculation formula in the "Calculation" box.

  2. To remove a field, select the field name and then click on the "Remove Field" button.

  3. To edit an existing entry, select a field name and then edit the field's attributes.

  4. To change the name of a field double-click it.

  5. To change the order in which the fields are listed, click the appropriate radio button (list in order by name or position).

On the "Links" tab:

DB Manager lets you specify links to secondary files. To add a link, click on the "Add a Link" button. A dialog is displayed prompting for the name of the link (for example, Cust.To.History), the file to link to, and the field that will be used to establish the link. Enter these values and then click on the "OK" button.

To remove a link, select the link and then click on the "Remove Link" button.

On the "Options" tab:

DB Manager includes several user-defined options. Use the "Options" tab to set or change these values.

The first option deals with the rules for exceeding the defined row size. To limit the definition to the defined row size, click on the upper button. To allow the program to automatically increase the row size if necessary, click on the lower button.

The second option deals with the rules for recalculating the field positions as changes are made. To be prompted each time, click on the upper button. To never make changes in the field positions, click on the middle button. To always make changes in the field positions, click on the lower button.

Deleting an Existing Definition

To delete an existing definition, select the definition and then click on the "Delete Definition" button.

Copying an Existing Definition

To copy an existing definition, select the definition and then click on the "Clone Definition" button. A dialog is displayed prompting for the name of the new definition. Enter a name and click on the "OK" button.

Viewing the File in Excel

To view the entire file in Excel, click on the "Excel View" button.

Viewing the File as XML

To export the entire file as XML including linked records if you wish, click on the "XML" button. The resultant file will be created in your TMP folder.

Utilities

The "Utilities" tab contains the following options:

Generate #CFILES

DB Manager includes the ability to import data dictionary information from #FILES or your .d00 files.

Click on the "Generate #CFILES" button.

Choose the directory where #CFILES is to be located, and then specify whether you want an empty #CFILES created, one built from #FILES, or one built from .d00 files. There is an option to merge the new definitions with an existing #CFILES.

Import from FORMAT

DB Manager also includes the ability to import a file layout from a FORMAT statement in a source program or include file.

Click on the "Import from FORMAT" button.

Select the type of source files to display (.inc, .ibs, CED) and then select the directory where the target source file is located. Select the source file from the list of available files.

Enter the definition name for the file. Enter the data file name and directory name to be associated with the definition, and select whether the file is an image file.

Enter the FORMAT name.

Click on the "Import" button.

Generate Include File

DB Manager includes the ability to generate an include file containing variable definitions and a FORMAT statement.

Click on the "Generate Include File" button.

Select the directory where the include file will be created. Enter a name for the include file.

Click on the "Generate" button.


Copyright © 1995 - 2008 Signature Systems, Inc.