SQL/MX 3.2.1 Reference Manual (H06.26+, J06.15+)

MXCI Commands
HP NonStop SQL/MX Release 3.2.1 Reference Manual—691117-004
4-98
Examples of SHOWDDL
•
This is an example of SHOWDDL on a sequence generator created with default
attribute values:
>>create sequence seq1;
--- SQL operation complete.
>>showddl seq1;
CREATE SEQUENCE CAT.SCH.SEQ1 LARGEINT
START WITH 1
INCREMENT BY 1
MINVALUE 1
MAXVALUE 9223372036854775807
NO CYCLE
LOCATION \HPIDMR5.$DATA07.ZSDFGVS8.Z1S98C00
;