REVALIDATE REFERENCES FOR
Purpose
When a referenced (or parent) or referencing (or child) table is restored, the reference is inconsistently marked in the database dictionary definitions. The table cannot be subject to updates, inserts or deletes.
REVALIDATE REFERENCES FOR validates reference indexes that are marked as inconsistent.
Syntax
where
Syntax Element |
Description |
(dbname) |
Name of database to be revalidated |
ALL |
Revalidates all child databases of specified database All database tables with inconsistent indexes are processed. |
(dbname.tablename) |
Name of a table in the database to be revalidated |
EXCLUDE |
Omits identified database from processing |
(dbname) |
Name of database excluded from processing |
ALL |
Excludes all child databases of specified database |
(dbname1) TO (dbname2) |
Alphabetical list of databases to be excluded from processing Database DBC is NOT included in this list. It will be excluded only if specifically identified. |
RELEASE LOCK |
Keywords to release HUT lock on table upon completion of processing (optional) |
ERRORDB |
Keyword to generate error tables in designated database (optional) |
(dbname) |
Name of database containing error tables generated If no table name is specified, error tables are created in the database containing the table being processed. |