Validate Data Integrity (ttaad4233m000)

Use this session to validate database contents according to the data dictionary.

The session reads a range of tables for the specified company numbers, verifies their contents based on the selected validation options, and prints a report. The report contains information such as table names, the number of records, and any errors.

Note: 
  • You can use the Maximum errors table field to limit the number of reported errors per table.
  • This session only validates the contents of tables. To check the presence of a table or the proper existence of the data dictionary, run the Check Tables (ttaad4232m000) session first.
Domain Integrity

If this check box is selected, the domain constraints are verified. If the validated database contents violate the domain constraints that are defined in the data dictionary, errors are reported.

If this check box is cleared, the domain constraints are ignored.

Referential Integrity (enhanced)

If this check box is selected, the referential integrity constraints are verified. If the validated database contents violate the referential integrity constraints, errors are reported.

If this check box is cleared, the referential integrity constraints are ignored.

Check High ASCII

This check box is default selected. An analyzation is done on the selected tables if high Ascii values are present. Errors for each field that contains one or more high Ascii characters are printed. You can switch between this option and the "Check High ASCII by Locale’ option.

If the LN server does not run in Unicode mode, you can select this check box to predict whether switching to Unicode will lead to problems.

If the LN server runs in Unicode mode, you can clear this check box to allow high Ascii values in single byte fields.

Note: 

You can clear this check box in these cases:

  • The high_ascii_tolerance resource is set and has value 1.
  • The high_ascii_tolerance resource is not set and the LN server does not run in Unicode mode.

In all other situations, the check box is disabled and selected, so the session checks for high Ascii values.

Check High ASCII by Locale

This option validates if high ASCII characters in single byte strings are allowed for a selected (installation) locale. The results are listed on a separate report.

Maximum errors table

The maximum number of errors that will be reported for each table.

Type a value less than or equal to 0, if you do not want to specify a maximum number of errors.