Resetting a sequence

[Former Member]

Hi,

Is there any simple way to reset a HDBSEQUENCE?

Suppose I have a sequence whose range is 1-100.

In a procedure  I need to reset the sequence and use it but for other procedures I need to just use NEXTVAL.

I have seen the syntax of create sequence with RESET BY option, but I want to just reset the sequence to its initial value .

Regards

S.Srivatsan

[lbreddemann]

Srivatsan Sundaravaradan wrote:

In a procedure  I need to reset the sequence and use it but for other procedures I need to just use NEXTVAL.

That's a design bug in your application.

If you need independent sequence numbers then use different sequences.

Remember, your code does not have control over the sequence. Any other process might request a new number any time. Resetting it at runtime is plain wrong.

- Lars