VERIFY()

VERIFY() determines whether a field contains valid data and, if so, returns a True value.

Note: When verifying fields in variable record length files, fields which start beyond the current record length are deemed invalid. This results in VERIFY() returning a false (F) value.

Because the Verify command and the Verify Data preference option do not allow very precise control, you can use the VERIFY() function to detect errors in individual fields and proceed in a situation-specific manner. For more information, see Verify and Verify Data.

Function Format

VERIFY(Field)

The VERIFY() function returns a True or False value depending on whether the field contains valid data.

Note: When verifying fields in variable record length files, fields which start beyond the current record length are deemed invalid. This results in VERIFY() returning a false (F) value.

Because computed fields and expressions always contain valid data, VERIFY() always returns True for computed fields and expressions.

Examples

To create a filter identifying invalid data in the Prodno field (which you could then use to extract the bad records), specify the condition:

VERIFY(Prodno) = F