Home
SQL programmingYou can use the HCL OneDB™ implementation of the SQL language to develop applications for HCL OneDB™ database servers.
Guide to SQL: SyntaxThe HCL OneDB™ Guide to SQL: Syntax describes the syntax of the statements, data types, expressions, operators, and built-in functions of the HCL OneDB™ dialect of the SQL language.
SQL statementsThis chapter describes the syntax and semantics of SQL statements that are recognized by HCL OneDB™.
CREATE SEQUENCE statementUse the CREATE SEQUENCE statement to create a sequence database object from which multiple users can generate unique integers.
START WITH Option

START WITH Option

Use the START WITH option to specify the first number of the sequence. This origin value must be an integer within the INT8 range that is greater than or equal to the min value (for an ascending sequence) or that is less than or equal to the max value (for a descending sequence), if min or max is specified in the CREATE SEQUENCE statement. The WITH keyword is optional.

If you do not specify an origin value, the default initial value is min for an ascending sequence or max for a descending sequence. (The MAXVALUE or NOMAXVALUE Option and MINVALUE or NOMINVALUE Option sections that follow describe the max and min specifications respectively.)