SQL/MX 2.x Reference Manual (H06.04+)

SQL/MX Utilities
HP NonStop SQL/MX Reference Manual—540440-003
5-85
Examples of VERIFY
STORE BY (C1 ASC);
CREATE INDEX VERIFY_T1_NDX2 ON payroll.dec2000.hourly
(
C3 ASC
)
LOCATION \SQUAW.$DATA08.ZSDVVVVV.T1X20100
NAME SQUAW_DATA08_ZSDVVVVV_T1X20100
PARTITION
(
ADD FIRST KEY (_ISO88591'a1')
LOCATION \SQUAW.$DATA08.ZSDVVVVV.T1X20200
NAME SQUAW_DATA08_ZSDVVVVV_T1X20200
EXTENT (16, 128) MAXEXTENTS 200
, ADD FIRST KEY (_ISO88591'a2')
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);
ALTER TABLE payroll.dec2000.hourly
ADD CONSTRAINT payroll.dec2000.hourly_chk1 CHECK
(payroll.dec2000.hourly.C2 > 0) DROPPABLE ;
•
This example shows the VERIFY operation run against table
payroll.dec2000.hourly, without options. VERIFY defaults to the -a option:
mxtool VERIFY payroll.dec2000.hourly
NonStop SQL/MX MXTOOL Utility 2.0
(c) Copyright 2003 Hewlett-Packard Development Company, LP.
All Rights Reserved.
Verifying table: payroll.dec2000.hourly
Verifying label for partition :
\SQUAW.$DATA08.ZSDVVVVV.T1000100
Verifying resource fork for partition:
\SQUAW.$DATA08.ZSDVVVVV.T1000100
Verifying constraints: \SQUAW.$DATA08.ZSDVVVVV.T1000100
Verifying Partition Map: \SQUAW.$DATA08.ZSDVVVVV.T1000100
Verifying Index Map : \SQUAW.$DATA08.ZSDVVVVV.T1000100
Verifying label for partition :
\SQUAW.$DATA08.ZSDVVVVV.T1000200
Verifying resource fork for partition:
\SQUAW.$DATA08.ZSDVVVVV.T1000200
Verifying constraints: \SQUAW.$DATA08.ZSDVVVVV.T1000200