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

MXCI Commands
HP NonStop SQL/MX Reference Manual—523725-004
4-77
Examples of SHOWDDL
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
;