SQL/MX 2.x Reference Manual (G06.24+, H06.03+)

SQL/MX Utilities
HP NonStop SQL/MX Reference Manual—523725-004
5-80
Examples of VERIFY
•
You must be the super ID, be owner of the schema where the object being verified
resides, or have SELECT privilege on the object being verified.
•
VERIFY obtains read-only locks on metadata while verifying an object. Other
operations that read metadata can run concurrently. Operations that change
metadata or labels such as DDL, partition management, PURGEDATA, and
UPDATE STATISTICS statements cannot run concurrently.
•
To verify some objects NonStop SQL/MX might need to access remote systems.
The remote system must be available and you must have privileges to view
information on it.
•
If VERIFY tries to access objects that have a schema version that is greater than
the SQL/MX software version (MXV) of the local node, you receive a versioning
error.
Examples of VERIFY
•
This example shows the creation of a table:
CREATE TABLE payroll.dec2000.hourly
C1 INT NO DEFAULT -- NOT NULL NOT DROPPABLE
, C2 INT DEFAULT NULL
, C3 CHAR(10) CHARACTER SET ISO88591 COLLATE DEFAULT
DEFAULT NULL
, CONSTRAINT payroll.dec2000.hourly_392165858_3314 PRIMARY
KEY (C1 ASC)
NOT DROPPABLE
, CONSTRAINT payroll.dec2000.hourly_328843858_3314 CHECK
(payroll.dec2000.hourly.C1 IS NOT NULL) NOT DROPPABLE
)
LOCATION \SQUAW.$DATA08.ZSDVVVVV.T1000100
NAME SQUAW_DATA08_ZSDVVVVV_T1000100
ATTRIBUTES EXTENT (64, 512), MAXEXTENTS 400
PARTITION
(
ADD FIRST KEY (1000)
LOCATION \SQUAW.$DATA08.ZSDVVVVV.T1000200
NAME SQUAW_DATA08_ZSDVVVVV_T1000200
EXTENT (16, 512) MAXEXTENTS 100
, ADD FIRST KEY (2000)
LOCATION \SQUAW.$DATA08.ZSDVVVVV.T1000300
NAME SQUAW_DATA08_ZSDVVVVV_T1000300
EXTENT (16, 512) MAXEXTENTS 200
, ADD FIRST KEY (3000)
LOCATION \SQUAW.$DATA08.ZSDVVVVV.T1000400
NAME SQUAW_DATA08_ZSDVVVVV_T1000400
EXTENT (16, 1024) MAXEXTENTS 300
)
STORE BY (C1 ASC);
CREATE INDEX VERIFY_T1_NDX2 ON payroll.dec2000.hourly
(