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

MXCI Commands
HP NonStop SQL/MX Reference Manual—540440-003
4-77
Examples of SHOWDDL
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
PARAMETER STYLE JAVA
CONTAINS SQL
NOT DETERMINISTIC
ISOLATE
;
>>showddl procedure T110_IO_NN;
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
PARAMETER STYLE JAVA
CONTAINS SQL
NOT DETERMINISTIC
ISOLATE
;