SQL$HELP72.HLB  —  ALTER  SEQUENCE  Arguments  CYCLE
    Syntax options:

    CYCLE | NOCYCLE

    The CYCLE clause specifies that the sequence is to continue
    generating values after reaching either the MINVALUE or MAXVALUE.
    After an ascending sequence reaches the MAXVALUE, the sequence
    starts again from its MINVALUE. After a descending sequence
    reaches its MINVALUE, the sequence starts again at its MAXVALUE.
    The NOCYCLE clause specifies that the sequence should not
    continue generating values after reaching either its minimum
    or maximum value. An error is generated if an attempt is made to
    increment the sequence beyond its limits.

    Note that even after you alter the CYCLE clause, those who
    were using the sequence at the time you altered the CYCLE will
    continue to use the original setting.
Close Help