Previous Topic: Sample OutputNext Topic: VALIDATE Syntax

Utility Statements › VALIDATE

VALIDATE

The VALIDATE utility checks linked and unlinked referential constraints for a referencing table, making sure that referenced tables exist and contain the appropriate column values.

Type of VALIDATE

What it does

Complete VALIDATE

Runs both STEP1 and STEP2

Stepped VALIDATE

Runs one step at a time with intermediate file sorting required between STEP1 and STEP2

Authorization

To

You need this privilege

On

Validate a table

SELECT

The table

Validate the tables in an area

SELECT

All tables in the area

Validate the tables in a segment

SELECT

All tables in the segment