DBDCHK

The dbdchk data validation program allows you to load and validate data in the Vulcan databases (including the ODBC Link database). The program is run from the command line and has two parts: loading and validating. Data will be loaded into a database without validating unless you optionally select validation. The validation option allows two types of validation:

• Field-by-field Validation
  This allows you to check the contents of a specified field against a variety of possible entries for that field, for example check if the logging codes are valid, if the data lies in certain ranges, and that data has been entered into a mandatory entry field.
• Global Validation
  This allows the contents of a field to be checked against the contents of all other occurrences of that field in the database, for example the hole name and/or eastings/northings for a hole will be checked against every other hole in the database.

---