CREATE SEQUENCE

The CREATE SEQUENCE statement creates a sequence at the application server.

Example:

Create a sequence called ORG_SEQ that starts at 1, increments by 1, does not cycle, and caches 24 values at a time:
CREATE SEQUENCE ORG_SEQ
       START WITH 1
       INCREMENT BY 1
       NO MAXVALUE
       NO CYCLE
       CACHE 24

For more information, see CREATE SEQUENCE in the SQL Reference topic in the Information CenterLink to Information center.