SQL/MX 2.x Reference Manual (G06.24+, H06.03+)

SQL/MX Statements
HP NonStop SQL/MX Reference Manual—523725-004
2-93
Examples of CREATE TABLE
(
A INT NO DEFAULT -- NOT NULL NOT DROPPABLE
, B INT DEFAULT NULL
, CONSTRAINT J1.SCH1.TAB1_264669593_1268 PRIMARY KEY
(A ASC) NOT DROPPABLE
, CONSTRAINT J1.SCH1.TAB1_535649593_1268 CHECK
(J1.SCH1.TAB1.A IS NOT NULL)
NOT DROPPABLE
)
LOCATION \CARNAG.$SARA.ZSDCL87P.DMP33T00
NAME CARNAG_SARA_ZSDCL87P_DMP33T00
ATTRIBUTES EXTENT (1024, 1024), MAXEXTENTS 16
PARTITION
(
ADD FIRST KEY (2)
LOCATION \CARNAG.$HIJO.ZSDCL87P.GHV33T00
NAME PARTITION1
EXTENT (1024, 1024) MAXEXTENTS 16
, ADD FIRST KEY (512)
LOCATION \CARNAG.$CHINA.ZSDCL87P.ZN133T00
NAME PARTITION2
EXTENT (1024, 1024) MAXEXTENTS 16
)
STORE BY (A ASC)
;
--- SQL operation complete.
•
Perform SHOWDDL to display tab2’s properties. Note that the partitions are
now named CARNAG_HIJO_ZSDCL87P_PT245W00 and
CARNAG_CHINA_ZSDCL87P_S1645W00:
>>showddl tab2;
CREATE TABLE J1.SCH1.TAB2
(
A INT NO DEFAULT -- NOT NULL NOT DROPPABLE
, B INT DEFAULT NULL
, CONSTRAINT J1.SCH1.TAB2_378461764_1268 PRIMARY KEY
(A ASC) NOT DROPPABLE
, CONSTRAINT J1.SCH1.TAB2_753441764_1268 CHECK
(J1.SCH1.TAB2.A IS NOT NULL)
NOT DROPPABLE
)
LOCATION \CARNAG.$SARA.ZSDCL87P.H5V45W00
NAME CARNAG_SARA_ZSDCL87P_H5V45W00
ATTRIBUTES EXTENT (1024, 1024), MAXEXTENTS 16
PARTITION
(
ADD FIRST KEY (2)
LOCATION \CARNAG.$HIJO.ZSDCL87P.PT245W00
NAME CARNAG_HIJO_ZSDCL87P_PT245W00
EXTENT (1024, 1024) MAXEXTENTS 16
, ADD FIRST KEY (512)
LOCATION \CARNAG.$CHINA.ZSDCL87P.S1645W00