PURPOSE: The CHECK command verifies that the data in records of the current Data Set (DS) is correct according to the descriptions and the validation criteria specified in the Schema Definition (SD). For all invalid records, the record number and the field names are displayed.
CHECK [/USE/ DOMAIN name] [WHEN clause] [{IF; UNLESS} clause] [[APPEND]
ERRORS TO ds_name] [{STOP; END} clause]
|
/USE/ DOMAIN name |
specifies the domain of a Data Index (DI). |
|
WHEN clause |
limits the check to records having the specified key field values when a DI is in use. Described in detail in Chapter 7. |
|
{IF; UNLESS} clause |
described in detail in Chapter 7. |
|
APPEND ERRORS TO ds_name |
appends the records containing errors to an existing DS. The output DS must reside in the current Data Base Library (DBL) and have the same SD as the current DS. |
|
ERRORS TO ds_name |
clears an existing DS and writes the records containing errors to it. The output DS must reside in the current DBL and have the same SD as the current DS. |
|
{STOP; END} clause |
described in detail in Chapter 7. |
*CHECK
RECORDS CONTAINING ERRORS
-------------------------------
ERROR INPUT FIELD
NUM RECORD NAME
-------------------------------
1 27 PRICE
2 183 ADVANCE_AMT
*******************************
2 Record(S) contain data errors