Re: Sequence Generator increments more than expected

Thanks for the feedback. Unfortunately, this is not the case. I did not have CACHE in my create statement, but in the event that it might have created 2 as the default, I dropped the sequence and re-created it using NOCACHE. It still does the same thing-the first number it generated was 3, the next number, 6.

Matt Southcott <matts_at_xxxnifcosynergy.com> wrote in article <34635f6e.62692897_at_news.bctel.net>...
> This is usually caused by the cache setting of the sequence check the
> cach setting it could be caching 10 sequences for every session that
> calls it.
Received on Fri Nov 07 1997 - 00:00:00 CET