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

SQL/MX Statements

HP NonStop SQL/MX Release 3.2.1 Reference Manual—691117-005

2-102

Considerations for CREATE SEQUENCE

Authorization Requirements

To create a sequence generator, you must own its schema or be the Super ID.

Restrictions

The CACHE and ORDER attributes are only supported syntactically. A warning

is returned if you use them in the CREATE SEQUENCE statement.

You cannot specify the INCREMENT BY, MAXVALUE or NOMAXVALUE or

NO MAXVALUE, MINVALUE or NOMINVALUE or NO MINVALUE, CYCLE or

NO CYCLE or NOCYCLE attributes more than once in the statement.

Reserved Names

The user metadata table names are reserved. You cannot create a sequence

generator with these reserved names. For example, you cannot create a sequence

generator named HISTOGRAMS.

Examples of CREATE SEQUENCE

•

This example creates a sequence generator with default attribute values:

CREATE SEQUENCE CAT.SCH.MYSEQ LARGEINT

•

This example creates a sequence generator specifying values for MINVALUE,

MAXVALUE and INCREMENT BY attributes:

CREATE SEQUENCE CAT.SCH.MYSEQ LARGEINT

START WITH 100

INCREMENT BY 1

MINVALUE 100

MAXVALUE 1000000 ;

•

This example creates a sequence generator in the specified Guardian location:

CREATE SEQUENCE SEQ2 LOCATION $DATA04;