VERIFY.CONSTRAINTS

The VERIFY.CONSTRAINTS command is used to check whether data in a file complies with data integrity constraints.

Format

VERIFY.CONSTRAINTS file.name

VERIFY.CONSTRAINTS file.name,subfile.name

VERIFY.CONSTRAINTS file.name,*

where

file.name

is the name of the file for which data integrity constraints are to be checked. This must correspond to a VOC F-type record.

subfile.name

is the name of the subfile if file.name references a multi-file. Use of an asterisk as the subfile name checks the constraints in all subfiles.

The data integrity constraint rules are defined in field 12 of D, A or S-type records in the dictionary. If the rules are changed, the VERIFY.CONSTRAINTS command can be used to check that existing records meet the new rules.

On completion of the command, @SYSTEM.RETURN.CODE will be zero if all records comply with the new rules, a positive number of errors detected or a negative error number.