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.
Data types and expressionsThese topics describe the data types and expressions that HCL OneDB™supports.
Expression
Constant ExpressionsCertain expressions that return a fixed value are called constant expressions. These include variant function operators that read the system clock, but that are valid in contexts where literal constants are also valid.
NEXTVAL and CURRVAL Operators
Using CURRVAL

Using CURRVAL

Any reference to CURRVAL returns the current value of the specified sequence, which is the value that your last reference to NEXTVAL returned. After you generate a new value with NEXTVAL, you can continue to access that value using CURRVAL, regardless of whether another user increments the sequence.

If both sequence.CURRVAL and sequence.NEXTVAL occur in an SQL statement, the sequence is incremented only once. In this case, each sequence.CURRVAL and sequence.NEXTVAL expression returns the same value, regardless of the order of sequence.CURRVAL and sequence.NEXTVAL within the statement.

Have feedback?
Google Analytics is used to store comments and ratings. To provide a comment or rating for a topic, click Accept All Cookies or Allow All in Cookie Preferences in the footer of this page.