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

SQL/MX Utilities
HP NonStop SQL/MX Reference Manual—540440-003
5-69
Examples of MXGNAMES
_ISO88591'abcd'
, C4 SMALLINT NO DEFAULT -- NOT NULL NOT
DROPPABLE
, CONSTRAINT CAT.SCH.T126A_106009919_0001 PRIMARY KEY (C1 ASC, C2 ASC)
NOT DROPPABLE
, CONSTRAINT CAT.SCH.T126A_106009919_0000 CHECK (CAT.SCH.T126A.C1 IS
NOT NULL
AND CAT.SCH.T126A.C2 IS NOT NULL AND CAT.SCH.T126A.C4 IS NOT NULL)
NOT
DROPPABLE
)
LOCATION \NSK.$VOL1.ZSDA126A.BXNL1R00
NAME PART_A_Z_1
PARTITION
(
ADD FIRST KEY (1000)
LOCATION \NSK.$VOL2.ZSDA126A.BXNL2R00
NAME PART_A_B_C
, ADD FIRST KEY (2000)
LOCATION \NSK.$VOL3.ZSDA126A.BXNL3R00
NAME PART_D_E_F
, ADD FIRST KEY (3000)
LOCATION \NSK.$VOL4.ZSDA126A.BXNL4R00
NAME PART_J_K_L
, ADD FIRST KEY (4000)
LOCATION \NSK.$VOL5.ZSDA126A.BXNL5R00
NAME PART_M_N_O
, ADD FIRST KEY (5000)
LOCATION \NSK.$VOL6.ZSDA126A.BXNL6R00
NAME PART_P_Q_R
)
STORE BY (C1 ASC, C2 ASC)
;
CREATE INDEX T126A_NDX1 ON CAT.SCH.T126A
(
C4 ASC
)
LOCATION \NSK.$VOL1.ZSDA126A.QDXWG100
NAME PART_V_W_X PARTITION
(
ADD FIRST KEY (100)
LOCATION \NSK.$VOL2.ZSDA126A.QDXWG200
NAME PART_S_T_U
, ADD FIRST KEY (500)
LOCATION \NSK.$VOL3.ZSDA126A.QDXWG300
NAME PART_Y_Z_1
, ADD FIRST KEY (700)
LOCATION \NSK.$VOL4.ZSDA126A.QDXWG400
NAME PART_A_Z_1
)
;
The resulting contents of file NAMELST would be:
(-- Table CAT.SCH.T126A -- &
$VOL1.ZSDA126A.BXNL1R*,&
$VOL2.ZSDA126A.BXNL2R*,&
$VOL3.ZSDA126A.BXNL3R*,&
$VOL4.ZSDA126A.BXNL4R*,&
$VOL5.ZSDA126A.BXNL5R*,&
$VOL6.ZSDA126A.BXNL6R*,&
&
-- Index T126A_NDX1 on CAT.SCH.T126A -- &
$VOL1.ZSDA126A.QDXWG1*,&
$VOL2.ZSDA126A.QDXWG2*,&
$VOL3.ZSDA126A.QDXWG3*,&