SQL/MX 2.x Installation and Management Guide (G06.24+, H06.03+)

Using Guardian Names With TMF, RDF, and
Measure
HP NonStop SQL/MX Installation and Management Guide—523723-004
B-6
MXGNAMES Examples
Given the file SHOWD123:
CREATE TABLE CAT.SCH.T126A
(
C1 INT NO DEFAULT -- NOT NULL NOT DROPPABLE
, C2 TIMESTAMP(6) DEFAULT CURRENT_TIMESTAMP -- NOT NULL NOT
DROPPABLE
, C3 CHAR(4) CHARACTER SET ISO88591 COLLATE DEFAULT
DEFAULT_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.ZSD0126A.BXNL1R00
NAME PART_A_Z_1
PARTITION
(
ADD FIRST KEY (1000)
LOCATION \NSK.$VOL2.ZSD0126A.BXNL2R00
NAME PART_A_B_C
, ADD FIRST KEY (2000)
LOCATION \NSK.$VOL3.ZSD0126A.BXNL3R00
NAME PART_D_E_F
, ADD FIRST KEY (3000)
LOCATION \NSK.$VOL4.ZSD0126A.BXNL4R00
NAME PART_J_K_L
, ADD FIRST KEY (4000)
LOCATION \NSK.$VOL5.ZSD0126A.BXNL5R00
NAME PART_M_N_O
, ADD FIRST KEY (5000)
LOCATION \NSK.$VOL6.ZSD0126A.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.ZSD0126A.QDXWG100
NAME PART_V_W_X PARTITION
(
ADD FIRST KEY (100)
LOCATION \NSK.$VOL2.ZSD0126A.QDXWG200
NAME PART_S_T_U
, ADD FIRST KEY (500)
LOCATION \NSK.$VOL3.ZSD0126A.QDXWG300
NAME PART_Y_Z_1
, ADD FIRST KEY (700)
LOCATION \NSK.$VOL4.ZSD0126A.QDXWG400