>>-CREATE SEQUENCE--sequence-name-------------------------------> .---------------------------------------------. V (1) | >----+------------------------------------+------+------------->< | .-INTEGER---. | +-AS--+-data-type-+------------------+ +-START WITH--numeric-constant-------+ | .-1----------------. | +-INCREMENT BY--+-numeric-constant-+-+ | .-NO MINVALUE----------------. | +-+-MINVALUE--numeric-constant-+-----+ | .-NO MAXVALUE----------------. | +-+-MAXVALUE--numeric-constant-+-----+ | .-NO CYCLE-. | +-+-CYCLE----+-----------------------+ | .-CACHE--20---------------. | +-+-NO CACHE----------------+--------+ | '-CACHE--integer-constant-' | | .-NO ORDER-. | '-+-ORDER----+-----------------------'
data-type: |--+-built-in-type------+---------------------------------------| '-distinct-type-name-' built-in-type: |--+-+---SMALLINT---+---------------------------+---------------| | +-+-INTEGER-+--+ | | | '-INT-----' | | | '---BIGINT-----' | | .-(5,0)-----------------. | '-+-+-DECIMAL-+-+--+-----------------------+-' | '-DEC-----' | | .-,0-. | '-NUMERIC-----' '-(--integer--+----+--)-'
(C) Copyright IBM Corporation 1992, 2006. All Rights Reserved.