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

MXCI Commands
HP NonStop SQL/MX Reference Manual—523725-004
4-76
Examples of SHOWDDL
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;
CREATE VIEW CAT.SCH.V1 AS
SELECT CAT.SCH.T2.KEYCOL, CAT.SCH.T2.VALCOL,
CAT.SCH.T2.SSN, CAT.SCH.T2.SALARY
FROM CAT.SCH.T2 TRANSPOSE CAT.SCH.T2.SSN,
CAT.SCH.T2.SALARY AS
CAT.SCH.T2.VALCOL KEY BY CAT.SCH.T2.KEYCOL;
•
This is an example of SHOWDDL on a stored procedure.
>>CREATE PROCEDURE CAT.SCH.T110_IO_NN
(
IN IN1 NUMERIC(9,3),
OUT OUT2 NUMERIC(9,3)
)
EXTERNAL NAME 't110.T110_io_nn
(java.math.BigDecimal,java.math.BigDecimal[])'
EXTERNAL PATH '/usr/ned/regress/udr'
LANGUAGE JAVA