On Mon, 2003-11-24 at 01:07, Christopher Kings-Lynne wrote:
> Hi,
>
> Is there demand for this syntax:
>
> ALTER SEQUENCE ON table(col) CYCLE 100;
>
> It would allow us to become sequence-name independent...
I think the right approach to this problem would be to implement
IDENTITIES and GENERATORS per 2k3 spec -- almost what you show here.
Check DB2 docs for examples.