Resetting a sequence
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 .