SQL$HELP72.HLB  —  CREATE  DATABASE  Arguments  RESERVE n SEQUENCES
    Specifies the number of sequences for which slots are reserved in
    the database. Sequences are reserved in multiples of 32. Thus, if
    you specify a value less than 32 for n, 32 slots are reserved. If
    you specify a value of 33, 64 slots are reserved, and so on.

    You can use the RESERVE SEQUENCES clause to reserve slots in
    the database root file for future use by the CREATE SEQUENCE
    statement. Sequences can be created only if sequence slots are
    available. Slots become available after a DROP SEQUENCE statement
    or a RESERVE SEQUENCES clause of the ALTER DATABASE statement is
    executed.

    The number of reserved slots for sequences cannot be decreased.

    If you do not specify the RESERVED SEQUENCES clause, the default
    number of sequence slots is 32.
Close Help