VERIFY command

Used to check for data validity errors in the current ACL table by verifying that the data in the ACL table is consistent with the field definitions in the table layout.

Syntax

VERIFY {<FIELDS> field <...n>| ALL} <IF test> <WHILE test> <{FIRST|NEXT} range>
<ERRORLIMIT n> <TO SCREEN|filename|PRINT> <APPEND>

Parameters

FIELDS fields | ALL

Specifies the fields or expressions to be verified. Although you can check for their validity, computed fields, along with ad hoc expressions and binary fields, are by definition always valid. The FIELDS keyword can be omitted.

IF test

Optional. Specifies a condition that must be met. The command is only executed on records that pass the test.

WHILE test

Optional. Specifies that the command should only be executed while a condition is true. The command processing terminates as soon as the specified test evaluates as false, or the end of the table is reached.

FIRST | NEXT range

Optional. Specify FIRST to start processing at the first record or NEXT to start processing at the currently selected record. Use the range value to specify the number of records to process.

ERRORLIMIT n

Optional. Specifies the number of errors allowed before the command is terminated. The default value is 10.

TO SCREEN | filename | PRINT
  • Specify TO SCREEN to display the results in the ACL display area. This is the default output if the TO parameter is not specified.

  • Specify TO filename to write the results to a file. You must specify the filename value as a quoted string with the appropriate file extension. For example, specify the .TXT file extension to create a text file.

    For example: TO "Output.TXT"

    You can also specify an absolute or relative file path to an existing folder to write the file to.

    For example: TO "C:\Output.TXT" or TO "Results\Output.TXT"

  • Specify TO PRINT to send the results to the default printer.

APPEND

Optional. Specifies that command output should be appended to the end of an existing file instead of overwriting the existing file. You must ensure that the structure of the two files is identical when using this parameter, if maintaining a consistent file structure is important (e.g., when you are appending data to an existing ACL table), because ACL appends output to an existing file regardless of its structure.

ACL output variables

WRITEn

Stores the total number of data validity errors identified by the command.

Remarks

The VERIFY command compares the values in one or more fields to the data type specified for each of the fields in the table layout and reports any errors encountered. The command ensures the following:

For each error that is identified, the record number and field name are output, along with the invalid value in hexadecimal format.

Example

The following example verifies all of the columns in a table and sets the error limit to 10, so that the command stops processing if 10 errors are encountered.

VERIFY ALL ERRORLIMIT 10 TO "ImportErrors.txt"

Related reference
VERIFY( ) function


(C) 2013 ACL Services Ltd. All Rights Reserved. | Send feedback