Arranging Field Order in a Reorganized Database

When the reorganization of a database results in the addition of fields in tables from which customized reports are created using native interfaces instead of SQL, the database can be reorganized with garbage collection. Garbage collection ensures that the field order matches the order defined in dbdef and that is recognized by the customized reports.

To arrange field order in a reorganized database

  1. Create a text file containing the name of the table where a new field is added.

    For example, if a new field has been added to the REVIEW table, create the text file Garbagefile.txt.

    In Garbagefile. txt, type the string REVIEW.

    Save changes to the text file.

  2. At the QShell command prompt, type:

    dbreorg -lcG/Directory/Garbagefile.txt Productline

    where Directory is the directory path where you saved the text file you created in step 1, and Productline is the product line where the reorganized table is contained.

    A list of the changes that will be made is displayed.

  3. If no unexpected change is displayed, type the following at the QShell command prompt:

    dbreorg -G/Directory/Garbagefile.txt Productline

    This command implements the changes. The table is dumped, dropped, created and reloaded into the database.

    Note: This process may take a while to complete, especially for tables with many records.