Check Database Consistency

Edit online

About this task

Use the Check Database Consistency function to compare the definitions of each query, output record, and field with the associated data source, and to return a list of any inconsistencies. This function alerts you to inconsistencies in your database, but does not fix your map components.

Sterling B2B Integrator Map Editor also checks database consistency:

  • When you update the data source (SQL File Properties dialog box, on the Data Source tab)
  • As the first action of compiling the map

An inconsistency occurs if, for a field, the translator tries to extract from a query column data that is not returned by the data source.

To check database consistency:

Procedure

  1. Right-click the SQL root element. From the shortcut menu, select Check Database Consistency.

    Sterling B2B Integrator Map Editor verifies the consistency of the selected side of the map and displays the File Format Consistency Check dialog box, which displays any inconsistencies.

  2. Click OK to close the File Format Consistency Check dialog box.