Identifies the referencing table to validate.
Specifies the name of the schema that defines the table.
Specifies the identifier of the table.
Identifies the area containing tables to be validated. All referencing tables in the area will be validated.
Specifies the name of the segment containing the area.
Specifies the name of the area.
Identifies the segment containing tables to be validated. All referencing tables in the segment will be validated.
Specifies the name of the segment.
Directs the VALIDATE utility to send a message to the operator whenever a specified number of rows are processed.
The message states the phase and step currently being executed and the number of records processed.
Specifies the number of rows to validate before sending a message.
Directs the VALIDATE utility to either continue the validation when errors are detected or stop after a specified number of errors are detected.
By default, processing will not stop when errors are detected.
Detected errors are listed in the report generated by the VALIDATE utility.
Specifies the number of errors to detect before terminating.
Directs the VALIDATE utility to continue processing regardless of the number of errors detected.
CONTINUE is the default.
Validates only linked referential constraints and unlinked index-to-index referential constraints.
If other unlinked referential constraints are detected, VALIDATE STEP1 produces an intermediate work file to be used as input to VALIDATE STEP2. If no such file is produced, you do not need to run VALIDATE STEP2.
If you do not specify a STEP number, the VALIDATE utility will validate all linked and unlinked referential constraints, and is considered a complete VALIDATE.
Validates all unlinked referential constraints except index to index referential constraints.
|
Copyright © 2014 CA.
All rights reserved.
|
|