Data editing > Data validation > Column and code validation
 
Column and code validation
Quick reference
To validate columns and codes, type:
require [/code/] condition col1 [,col2 ...]
code
(Optional.) The error action code.
condition
The type of coding required.
col1 [, col2 ]
The columns or fields to be tested, separated by commas.
Example
r /5/ nb c110, c125
This example checks that columns 110 and 125 are not blank (nb). Any records in which this is not the case are written out to a new file and rejected from any tables that might be produced (/5/).
See
action code
Checking type of coding
Comments with require
Checking codes in columns
Exclusive codes
Automatic error correction
Defaults in a require statement
See also
Data validation