Creating Generators

Go Up to Working with Generators

To create a unique number generator in the database, use the CREATE ­GENERATOR statement. CREATE GENERATOR declares a generator to the database and sets its starting value to zero (the default). If you want to set the starting value for the generator to a number other than zero, use SET ­GENERATOR to specify the new value.

The syntax for CREATE GENERATOR is:

CREATE GENERATOR name;

The following statement creates the generator, EMPNO_GEN:

CREATE GENERATOR EMPNO_GEN;

Note:
Once defined, a generator cannot be deleted.

Advance To:

• Setting or Resetting Generator Values