Viewing or Modifying Sequence Generator Properties

View or change the properties of a sequence generator.

Prerequisites

Database Version	Sequence Generator Permissions
SAP Sybase IQ 15.3 and 15.4	View sequence generator properties – None required. Modify a sequence comment – Requires one of: DBA authority. RESOURCE authority. You own the sequence generator. Modify sequence permissions – Requires one of: DBA authority. PERMS ADMIN authority. You own the sequence generator. Modify any other sequence property – Requires one of: DBA authority. You own the sequence generator.
SAP Sybase IQ 16.0	View any sequence property page – None required. Modify a sequence comment – Requires one of: CREATE ANY SEQUENCE system privilege. ALTER ANY SEQUENCE system privilege. CREATE ANY OBJECT system privilege. ALTER ANY OBJECT system privilege. COMMENT ANY OBJECT system privilege. Modify sequence permissions – Requires one of: MANAGE ANY OBJECT PRIVILEGE system privilege. You own the sequence generator. Modify any other sequence property – Requires one of: ALTER ANY SEQUENCE system privilege. ALTER ANY OBJECT system privilege. You own the sequence generator.

Database Version

Sequence Generator Permissions

SAP Sybase IQ 15.3 and 15.4

View sequence generator properties – None required.

Modify a sequence comment – Requires one of:

DBA authority.
RESOURCE authority.
You own the sequence generator.

Modify sequence permissions – Requires one of:

DBA authority.
PERMS ADMIN authority.
You own the sequence generator.

Modify any other sequence property – Requires one of:

DBA authority.
You own the sequence generator.

SAP Sybase IQ 16.0

View any sequence property page – None required.

Modify a sequence comment – Requires one of:

CREATE ANY SEQUENCE system privilege.
ALTER ANY SEQUENCE system privilege.
CREATE ANY OBJECT system privilege.
ALTER ANY OBJECT system privilege.
COMMENT ANY OBJECT system privilege.

Modify sequence permissions – Requires one of:

MANAGE ANY OBJECT PRIVILEGE system privilege.
You own the sequence generator.

Modify any other sequence property – Requires one of:

ALTER ANY SEQUENCE system privilege.
ALTER ANY OBJECT system privilege.
You own the sequence generator.

The SAP Sybase IQ resource is authenticated and running.

Task

In the Perspective Resources view, select the resource and select Resource > Administration Console.
In the left pane, select IQ Servers > Schema Objects > Sequence Generators.
Select a sequence generator from the right pane and either:
- Click the arrow to the right of the name and select Properties, or
- From the Administration Console menu bar, select Resource > Properties.

View or modify the properties.

When modifying properties, clicking Apply before changing screens is not necessary, but will save any changes.
If you do not have privileges to modify properties, Sybase Control Center displays the properties view in read-only mode.

Area	Description
General page	Name – (Read-only) Name of the selected sequence generator. Owner – (Read-only) Assigned owner of the selected sequence generator. Minimum value – Minimum value for the sequence generator. Default value is 1. Valid range is -9223372036854775808 to 9223372036854775807. Maximum value – Maximum value for the sequence generator. Default value is 1. Valid range is -9223372036854775808 to 9223372036854775807. Start value – Starting value for the sequence generator. Default value is 1. Valid range is -9223372036854775808 to 9223372036854775807. Increment value – Incremental value for the sequence generator. Default value is 1. Valid range is -9223372036854775808 to 9223372036854775807. Cycle values – Select if the sequence generator is to continue generating values [starting over at the start value] once minimum or maximum values have been reached. Option unselected by default. Cache size – Determines the number of preallocated sequence values that are kept in memory for faster access. Default value is 100. Valid range is 0 to unlimited Comment – A text field for adding an optional comment about the sequence generator.
Permissions	See Granting Sequence Generator USAGE Permission and Revoking Sequence Generator USAGE Permission.

Area

Description

General page

Name – (Read-only) Name of the selected sequence generator.

Owner – (Read-only) Assigned owner of the selected sequence generator.

Minimum value – Minimum value for the sequence generator. Default value is 1. Valid range is -9223372036854775808 to 9223372036854775807.

Maximum value – Maximum value for the sequence generator. Default value is 1. Valid range is -9223372036854775808 to 9223372036854775807.

Start value – Starting value for the sequence generator. Default value is 1. Valid range is -9223372036854775808 to 9223372036854775807.

Increment value – Incremental value for the sequence generator. Default value is 1. Valid range is -9223372036854775808 to 9223372036854775807.

Cycle values – Select if the sequence generator is to continue generating values [starting over at the start value] once minimum or maximum values have been reached. Option unselected by default.

Cache size – Determines the number of preallocated sequence values that are kept in memory for faster access. Default value is 100. Valid range is 0 to unlimited

Comment – A text field for adding an optional comment about the sequence generator.

Permissions

See Granting Sequence Generator USAGE Permission and Revoking Sequence Generator USAGE Permission.

Click OK.