EM: Databases/SQL: Databases > Sequences

Description

The Databases, Sequences tab lists defined database sequences and their key values, including current value, increment, minimum, maximum, and cycle status.

Note: selecting a database from Databases name list, opens its configuration interface, and enabling access to Sequences.

Location

EM Navigator → Databases/SQL → Databases → Sequences

Toolbar

Button Function

Creates a new sequence.

Deletes/Removes selected sequence.

Refreshes the information.

Sequences Column

The Sequences column presents each defined sequence with its Sequence Name, Current value, Increment, Min., Max., and Cycle setting.

Sequences Column Settings

Settings Description

Sequence Name

Name assigned to each sequence defined in the selected database.

Current

The current value presently stored for the sequence in the database.

Increment

The numeric amount added each time the sequence generates a value.

Min

Minimum value defined for the sequence in the database.

Max

Maximum value defined for the sequence in the database.

Cycle

Shows whether the sequence is set to cycle after reaching its maximum value.

Create a New Sequence

To create a new Sequence clicking the icon opens Create New Sequence dialog, where users define a sequence by entering its name, start value, increment, and maximum value. The dialog also explains that a sequence returns the next value at the specified increment when called from an SQL statement.

New Sequence Settings

Settings Description

Sequence Name

The name used to identify the sequence within the selected database.

Start Value

The initial value assigned when the sequence is first created.

Increment

The numeric amount added each time the sequence advances forward.

Maximum Value

Sets the highest value the sequence can reach before stopping incrementing.

See Also

BBjAdminBase

Databases

Connections

JDBC How-To

SQL

Tables

Views

Procedures

Types

Security

Query Analysis

Permissions

Connection Pools

SQL/SELECT Connections

Table Analysis Queue

Index Builders