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

MXCI Commands
HP NonStop SQL/MX Reference Manual—540440-003
4-76
Examples of SHOWDDL
CATALOG \FIGARO.$DATA17.DEANCAT
PARTITION (
\FIGARO.$DATA14.DEANCAT.T1
FIRST KEY 5000
)
;
CREATE CONSTRAINT C1 on \FIGARO.$DATA17.DEANCAT.T1 CHECK SID
> 1000;
•
This is an example of SHOWDDL on a table with a trigger. The DDL of the triggers
is shown, but the ALTER TRIGGER DISABLE statement is not displayed for
triggers that are disabled.
>>CREATE TABLE T074T3
(A INT NOT NULL, B INT, C CHAR(8), D INT, PRIMARY KEY(A));
>>CREATE TRIGGER BTR BEFORE UPDATE ON T074T3
REFERENCING OLD AS MYOLDROW,
NEW AS MYNEWROW WHEN (MYNEWROW.D > MYOLDROW.D)
SET MYNEWROW.B = MYNEWROW.B + MYOLDROW.D;
>>SHOWDDL T074T3;
CREATE TABLE CAT.SCH.T074T3
(
A INT NO DEFAULT -- NOT NULL NOT DROPPABLE
, B INT DEFAULT NULL
, C CHAR(8) CHARACTER SET ISO88591 COLLATE
DEFAULT DEFAULT NULL
, D INT DEFAULT NULL
, CONSTRAINT CAT.SCH.T074T3_102459148_0001
PRIMARY KEY (A ASC) NOT DROPPABLE
, CONSTRAINT CAT.SCH.T074T3_102459148_0000
CHECK (CAT.SCH.T074T3.A IS NOT
NULL) NOT DROPPABLE
)
LOCATION \FIGARO.$DATA.ZSDADM53.QUSGEI00
NAME FIGARO_DATA_ZSDADM53_QUSGEI00
;
CREATE TRIGGER CAT.SCH.BTR
BEFORE UPDATE ON CAT.SCH.T074T3 REFERENCING OLD AS
MYOLDROW, NEW AS MYNEWROW
WHEN (MYNEWROW.D > MYOLDROW.D) SET MYNEWROW.B =
MYNEWROW.B + MYOLDROW.D;
;
•
This is an example of SHOWDDL on a view.
>>CREATE VIEW V1
AS SELECT keycol, valcol, ssn, salary
FROM T2
TRANSPOSE SSN, salary AS valcol
KEY BY keycol;
>>SHOWDDL V1;