SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
V-5
Examples-VERIFY
Repairing Views
Both the protection view and short hand view, after re-creation, contain a new
creation timestamp in the physical objects (file label) and catalog. This invalidates
the programs using these views, which might call for recompilation of the
programs.
Usage of File Sets With Wild-Card Characters in Repair
File sets used in the VERIFY command, such as $VOL.SUBVOL.T* cannot be
repaired because the filenames are extracted from a disk. The file to be repaired
must be fully qualified. File sets with wild-card characters work when the FROM
CATALOG option is chosen.
Examples-VERIFY

This example verifies objects and locates invalid programs in the SALES catalog:
>> VERIFY *.*.* FROM CATALOG SALES;
--- Verifying $VOL1.SALES.ASSERTS
--- $VOL1.SALES.ASSERTS Verified.
--- Verifying $VOL1.SALES.BASETABS
--- $VOL1.SALES.BASETABS Verified.
...
(any invalid programs are listed)
...
--- SQL operation complete.

This example verifies the EMPLOYEE table:
>> VERIFY $VOL1.PERSNL.EMPLOYEE;
--- Verifying $VOL1.PERSNL.EMPLOYEE
--- $VOL1.PERSNL.EMPLOYEE Verified.
--- SQL operation complete.

This example creates a command file named RECOMPF for recompiling invalid
SQL programs in Guardian files in the SALES catalog:
>> VERIFY $VOL1.SALES.* FROM CATALOG SALES WHERE SQLPROGRAM
+> SOURCE RECOMPF CLEAR;
...
PROGRAM \SYS.$VOL1.SALES.PROGA
*** WARNING $VOL1.SALES.PROGA is an invalid program.
The RECOMPF file contains this command:
SQLCOMP /IN \SYS1.$VOL1.SALES.PROGA, OUT file/STOREDEFINES
The current SQLCI OUT file is used in the SQLCOMP command.