SQL/MX 3.2 Reference Manual (H06.25+, J06.14+)

SQL/MX Utilities
HP NonStop SQL/MX Release 3.2 Reference Manual—691117-001
5-145
Examples of VERIFY
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
(
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