DYNAMIC-CURRENT-VALUE function

Returns the current INT64 value of a sequence defined in the specified database.

Syntax

DYNAMIC-CURRENT-VALUE( 
  sequence-expression , logical-dbname-expression  [ , tenant-id ] )
sequence-expression
A character expression that evaluates to the name of a sequence.
logical-dbname-expression
A character expression that evaluates to the name of a connected database in which the sequence is defined.
tenant-id
An integer expression that evaluates to the tenant ID of a regular tenant, including the default tenant (0). This option applies only to a multi-tenant sequence specified by sequence-expression and is intended for access primarily by a super-tenant user.

If you are a regular-tenant user and you specify tenant-id, the specified tenant must be the same as the tenant associated with the database connection identity for logical-dbname-expression or the AVM raises a run-time error.

If you are a super-tenant user and you do not specify tenant-id, the function assumes the effective tenant ID (GET-EFFECTIVE-TENANT-ID function).

If the sequence specified by sequence-expression is non-multi-tenant (a shared sequence in a multi-tenant database), and you specify tenant-id, the option is ignored.

Notes

See also

CURRENT-VALUE function, DYNAMIC-CURRENT-VALUE statement, DYNAMIC-CURRENT-VALUE statement, DYNAMIC-NEXT-VALUE function, NEXT-VALUE function