SQL/MP Installation and Management Guide

Querying SQL/MP Catalogs
HP NonStop SQL/MP Installation and Management Guide—523353-004
6-13
Using VERIFY to Check Definitional Integrity
catalog SALES and that have a FILECODE value less than 572. This report does not
verify catalog tables because their file codes are not less than 572.
>> VERIFY *.*.* FROM CATALOG SALES WHERE FILECODE < 572;
--- Verifying $VOL1.SALES.ATABLE1
--- $VOL1.SALES.ATABLE1 verified.
--- Verifying $VOL1.SALES.AVIEW1
--- $VOL1.SALES.AVIEW1 verified.
--- Verifying $VOL1.SALES.AINDEX1
--- $VOL1.SALES.AINDEX1 verified.
--- SQL operation complete.
This example verifies the definition of a single object, the table EMPLOYEE:
>> VERIFY DEF OF $VOL1.PERSNL.EMPLOYEE;
--- Verifying $VOL1.PERSNL.EMPLOYEE
--- $VOL1.PERSNL.EMPLOYEE verified.
--- SQL operation complete.
This example shows the error generated by an invalid object in the catalog SALES:
>> VERIFY *.*.* FROM CATALOG $DATA1.SALES;
--- Verifying $DATA1.SALES.ODETAIL
--- $DATA1.SALES.ODETAIL verified.
--- Verifying $DATA1.SALES.ORDERS
--- $DATA1.SALES.ORDERS verified.
--- Verifying $DATA1.SALES.ORDREP
*** ERROR from SQL [-1233]: The catalog entry in the TABLES
table
*** for \SQLA.$DATA1.SALES.ORDREP indicates an invalid COLCOUNT:
0.
*** ERROR from SQL [-9881]: Unable to obtain catalog definition
for
*** SQL shorthand view object.
--- SQL operation complete.