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. Modify a sequence comment – you must have one of: DBA authority RESOURCE authority You own the sequence generator Modify sequence permissions – You must have one of: DBA authority PERMS ADMIN authority You own the sequence generator Modify any other sequence property – you must have one of: DBA authority You own the sequence generator
SAP Sybase IQ 16.0	View any sequence property page – none. Modify a sequence comment – you must have 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 – You must have one of: MANAGE ANY OBJECT PRIVILEGE system privilege You own the sequence generator Modify any other sequence property – you must have 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.

Modify a sequence comment – you must have one of:

DBA authority
RESOURCE authority
You own the sequence generator

Modify sequence permissions – You must have one of:

DBA authority
PERMS ADMIN authority
You own the sequence generator

Modify any other sequence property – you must have one of:

DBA authority
You own the sequence generator

SAP Sybase IQ 16.0

View any sequence property page – none.

Modify a sequence comment – you must have 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 – You must have one of:

MANAGE ANY OBJECT PRIVILEGE system privilege
You own the sequence generator

Modify any other sequence property – you must have 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, expand IQ Servers > Schema Objects, and then select 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, SAP 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.

Do one of:
- Click OK to update any changes to the database and exit the properties view.
- Click Apply to update any changes to the database, but remain in the properties view.
- Click Cancel to cancel any changes not updated to the database and exit the properties view.