SQL/MX 3.1 Reference Manual (H06.23+, J06.12+)

MXCI Commands
HP NonStop SQL/MX Release 3.1 Reference Manual—663850-001
4-94
Examples of SHOWDDL
)
LOCATION \FIGARO.$DATA2.ZSDUXXBK.B7VVVW00
NAME FIGARO_DATA2_ZSDQXXBK_B7VVVW00
ATTRIBUTES BLOCKSIZE 32768, MAXEXTENTS 600
;
•
The following example displays the sequence generator attributes for an IDENTITY
column:
CREATE TABLE CAT.SCH.T1
(
SURROGATE_KEY LARGEINT GENERATED ALWAYS AS IDENTITY
(START WITH 99 INCREMENT BY 2 MAXVALUE 900 MINVALUE 50 NO
CYCLE)
LOCATION \NSK.$SYSTEM.ZSDGNCWF.G423GN00
-- NOT NULL NOT DROPPABLE
, B INT UNSIGNED NO DEFAULT
-- NOT NULL NOT DROPPABLE
, CONSTRAINT CAT.SCH.T1_344545289_4325 PRIMARY KEY
(SURROGATE_KEY ASC) NOT
DROPPABLE
, CONSTRAINT CAT.SCH.T1_482894289_4325 CHECK
(CAT.SCH.T1.SURROGATE_KEY IS NOT
NULL AND CAT.SCH.T1.B IS NOT NULL) NOT DROPPABLE
)
LOCATION \NSK.$DATA.ZSDGNCWF.HWD7GN00
NAME NSK_DATA_ZSDGNCWF_HWD7GN00
ATTRIBUTES ALIGNED FORMAT, BLOCKSIZE 4096
STORE BY (SURROGATE_KEY ASC)
;