SQL/MX 2.x Reference Manual (H06.10+, J06.03+)

MXCI Commands
HP NonStop SQL/MX Reference Manual—544517-008
4-82
Examples of SHOWDDL
•
This is an example of SHOWDDL that reports the maximum number of result sets
the sales.order_summary procedure returns.
>>showddl samdbcat.sales.order_summary;
CREATE PROCEDURE SAMDBCAT.SALES.ORDER_SUMMARY
(
IN ON_OR_AFTER_DATE VARCHAR(20) CHARACTER SET ISO88591
, OUT NUM_ORDERS LARGEINT
)
EXTERNAL NAME 'SPJMethods.orderSummary
(java.lang.String,long[],java.sql.ResultSet[],java.sql.Result
Set[])'
EXTERNAL PATH '/usr/mydir/myclasses'
LOCATION \ALPINE.$SYSTEM.ZSDCR2C6.L1Z7NW00
LANGUAGE JAVA
PARAMETER STYLE JAVA
READS SQL DATA
DYNAMIC RESULT SETS 2
NOT DETERMINISTIC
ISOLATE
;
--- SQL operation complete.
•
This is an example of SHOWDDL on an SQL/MX table that contains BLOCKSIZE
with a value other than the default value.
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
, ADD FIRST KEY (1500)
LOCATION \FIGARO.$DATA.ZSDWWWWW.AADZ1200
NAME FIGARO_$DATA_ZSDWWWWW_AADZ1200
)
ATTRIBUTES BLOCKSIZE 32768, MAXEXTENTS 600
STORE BY (C1 ASC, C2 ASC);
CREATE UNIQUE INDEX T1_102261179_0004 ON CAT.SCH.T1
(
C1 ASC