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.
CACHE or NOCACHE OptionUse the CACHE option to specify the number of new sequence values that are preallocated in memory for rapid access. This option can enhance the performance of a sequence that grows quickly.

CACHE or NOCACHE Option

Use the CACHE option to specify the number of new sequence values that are preallocated in memory for rapid access. This option can enhance the performance of a sequence that grows quickly.

The cache size must be a positive whole number in the INT range. If you specify the CYCLE option, then size must be less than the number of values in a cycle (or less than |(max - min)/step|). The minimum is 2 preallocated values. The default is 20 preallocated values.

The NOCACHE keyword specifies that no generated values (that is, zero) are preallocated in memory for this sequence object.