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-99
CREATE SEQUENCE Statement
CREATE SEQUENCE Statement
Considerations for CREATE SEQUENCE
Examples of CREATE SEQUENCE
The CREATE SEQUENCE statement creates a sequence generator in the specified
schema. The CREATE SEQUENCE statement must specify a name, but specifying the
attributes such as LOCATION, START WITH, MAXVALUE, MINVALUE, INCREMENT
BY, and CYCLE is optional.
Note. Each attribute can be specified at most once in the CREATE SEQUENCE statement. A
warning is returned if you specify the ORDER and CACHE attributes.
CREATE SEQUENCE sequence [sequence-generator-options
[sequence-generator-options] ...] [sequence-file-option]
sequence-generator-options are:
{ sequence-generator-data-type-option }
| { sequence-generator-start-with-option }
| { sequence-generator-increment-by-option }
| { sequence-generator-maxvalue-option }
| { sequence-generator-minvalue-option }
| { sequence-generator-cycle-option }
| { sequence-generator-cache-option }
| { sequence-generator-order-option }
sequence-generator-data-type-option is:
{ NUMERIC [ (sg-precision [, 0]) ]
[ SIGNED | UNSIGNED ]
| SMALLINT [ SIGNED | UNSIGNED ]
| INT[EGER] [ SIGNED | UNSIGNED ]
| LARGEINT [ SIGNED ]
}
sg-precision is: { 1,2,3,...,28 }
sequence-generator-start-with-option is:
{ START WITH sequence-generator-numeric-value }
sequence-generator-increment-by-option is:
{ INCREMENT BY sequence-generator-numeric-value }
sequence-generator-maxvalue-option is:
{ MAXVALUE sequence-generator-numeric-value
| NOMAXVALUE
| NO MAXVALUE
}
sequence-generator-minvalue-option is:
{ MINVALUE sequence-generator-numeric-value
| NOMINVALUE
| NO MINVALUE
}