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

MXCI Commands
HP NonStop SQL/MX Reference Manual—540440-003
4-73
Examples of SHOWDDL
•
These are examples of SHOWDDL on tables with partitions that are offline. Note
the commenting out of partitions that are offline, and the whole partition clause if all
of the partitions are offline.
>>SHOWDDL T1;
CREATE TABLE CAT.SCH.T1
(
A INT DEFAULT NULL
, B INT NO DEFAULT -- NOT NULL NOT DROPPABLE
, C INT NO DEFAULT -- NOT NULL NOT DROPPABLE
, CONSTRAINT CAT.SCH.T1_104871912_0091
PRIMARY KEY (B ASC, C DESC) NOT DROPPABLE
, CONSTRAINT CAT.SCH.T1_104871912_0090 CHECK
(CAT.SCH.T1.B IS NOT NULL AND
CAT.SCH.T1.C IS NOT NULL) NOT DROPPABLE
)
LOCATION \FIGARO.$DATA.ZSDADM53.VZBRLI00
NAME FIGARO_DATA_ZSDADM53_VZBRLI00
-- HASH PARTITION
-- (
-- The following partition is offline --
-- ADD LOCATION \FIGARO.$DATA.ZSDWWWWW.AADZ1200
-- NAME FIGARO_$DATA_ZSDWWWWW_AADZ1200
-- )
STORE BY (B ASC, C DESC)
;
>>showddl t1;
CREATE TABLE CAT.SCH.T1
(
C1 INT NO DEFAULT -- NOT NULL NOT DROPPABLE
, C2 INT NO DEFAULT -- NOT NULL NOT DROPPABLE
, C3 INT DEFAULT NULL
, CONSTRAINT CAT.SCH.T1_104871911_0089
PRIMARY KEY (C1 ASC, C2 ASC) NOT DROPPABLE
, CONSTRAINT CAT.SCH.T1_104871911_0088 CHECK
(CAT.SCH.T1.C1 IS NOT NULL AND
CAT.SCH.T1.C2 IS NOT NULL) NOT DROPPABLE
)
LOCATION \FIGARO.$DATA.ZSDADM53.QUSGEI00
NAME FIGARO_DATA_ZSDADM53_QUSGEI00
PARTITION
(
ADD FIRST KEY (1200)
LOCATION \FIGARO.$DATA.ZSDWWWWW.AADZ1400
-- The following partition is offline --
-- ADD FIRST KEY (1300)
-- LOCATION \FIGARO.$DATA.ZSDWWWWW.AADZ1600
-- NAME FIGARO_$DATA_ZSDWWWWW_AADZ1600
, ADD FIRST KEY (1500)
LOCATION \FIGARO.$DATA.ZSDWWWWW.AADZ1200
NAME FIGARO_$DATA_ZSDWWWWW_AADZ1200
)