Purging and Rebuilding Delta Tables

When the compare and code page environments are out of synchronization, use the Delta Purge and Rebuild Process (R79801) to identify and fix problems. You should rebuild at the beginning of the translation lifecycle, but purge before mastering the software.

The purge process deletes these types of records:

• Status and language records that are marked for deletion (status = 99).

• Language records that do not have a corresponding status record.

  This means that the language record is extraneous because, without a corresponding status record, it does not match any of the English records. The translation record has become an orphan.

• All untranslated language records (status = 20).

  This removes bad translations. Untranslated text is a better result than a bad translation.

The rebuild process performs these tasks:

• Checks certain status records for missing translation records or untranslated text.

• Compares all status records that are complete (status = 11) for matching language records.

• Changes the status of the corresponding status record to either untranslated (status = 20) or new item (status = 40) for each language record that meets these conditions:

  • Record does not exist.

  • Record is blank.

  • Record contains English (you need to set a processing option for this function).

Access the Work With Batch Versions - Available Versions form.

1. Select the Purge and Rebuild version in the detail area and then select Processing Options from the Row menu.

2. On the Processing Options form, complete these fields on the Process tab and click OK:

   • Language

     Enter the language code, such as W for Swedish, for the language records that you want to purge and rebuild.

   • Translation Compare Environment

     Enter the compare environment or leave this processing option blank to use the default compare environment. The wrong compare environment can cause corruption in the database.

   • Code Page Environment

     Enter the language code page environment or leave this processing option blank to use the default code page environment. The wrong code page environment can cause corruption in the database.

   • Purge

     Leave this processing option blank to run the purge process. Enter 1 in this processing option to prevent the purge process from running.

   • Rebuild

     Leave this processing option blank to run the rebuild process. Enter 1 in this processing option to prevent the rebuild process from running.

   • Duplicate English

     Enter 1 in this processing option to run a process that checks language records for any source English that also appears in the source English records. Any duplicate source English changes the corresponding status record to untranslated (status = 20). Generally, translation memory problems cause English text to appear in translated software, and this process can reset the status appropriately.

3. On the Work With Batch Versions - Available Versions form, in the detail area, select the version that you want to run, and then click Select.

   The data selection is defined by the delta inclusion application.

   If the Processing Options form prompts for editing, click OK; the system displays the Report Output Destination form.

4. Select one of these options, and then click OK:

   • On Screen

   • To Printer

     The batch process runs.

     Note: The purge and rebuild process also rebuilds information in the code page records. Tables such as F0005D, F7920, and F98306 contain information from the source records. This process fixes translation or mastering issues.