Creating a Sequence


You can use SQL Studio to create new sequences in the database.


You need to have the necessary user authorizations and the NOT EXCLUSIVE user attribute.

For an explanation of user authorizations and user attributes, see the Database Users section of the Concepts of the Database System documentation and the Authorization section of the SQL Reference Manual.



       1.      Choose Catalog Manager® New ® Sequence Definition.

       2.      Enter a name for the sequence, and define the required values.

       3.      Choose Sequence Definition ® Create Sequence.

       4.      To export the SQL statement for creating the sequence to the SQL dialog, choose Sequence Definition ® Export to SQL Dialog.

For information on the syntax of CREATE SEQUENCE statements, see the CREATE SEQUENCE Statement section of the SQL Reference Manual.