SQL/MX 3.2.1 Reference Manual (H06.26+, J06.15+)

SQL/MX Utilities
HP NonStop SQL/MX Release 3.2.1 Reference Manual—691117-005
5-83
Examples of VERIFY
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
Verifying Partition Map: \SQUAW.$DATA08.ZSDVVVVV.T1000200
Verifying Index Map : \SQUAW.$DATA08.ZSDVVVVV.T1000200
Verifying label for partition :
\SQUAW.$DATA08.ZSDVVVVV.T1000300
Verifying resource fork for partition:
\SQUAW.$DATA08.ZSDVVVVV.T1000300
Verifying constraints: \SQUAW.$DATA08.ZSDVVVVV.T1000300
Verifying Partition Map: \SQUAW.$DATA08.ZSDVVVVV.T1000300
Verifying Index Map : \SQUAW.$DATA08.ZSDVVVVV.T1000300
Verifying label for partition :
\SQUAW.$DATA08.ZSDVVVVV.T1000400
Verifying resource fork for partition:
\SQUAW.$DATA08.ZSDVVVVV.T1000400
Verifying constraints: \SQUAW.$DATA08.ZSDVVVVV.T1000400
Verifying Partition Map: \SQUAW.$DATA08.ZSDVVVVV.T1000400
Verifying Index Map : \SQUAW.$DATA08.ZSDVVVVV.T1000400