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.
INCREMENT BY Option

INCREMENT BY Option

Use the INCREMENT BY option to specify the interval between successive numbers in the sequence. The BY keyword is optional. The interval, or step value, can be a positive whole number (for an ascending sequence) or a negative whole number (for a descending sequence) in the INT8 range. If you do not specify any step value, the default interval between successive generated values is 1, and the sequence is an ascending sequence.