Amrita Chaudhury wrote:

> We cant use set generator inside stored procs, can we ??

No, but you can set the generator's value by using the GEN_ID function
(also inside SP):
gen_id(MY_GENERATOR, NEW_VALUE - gen_id(MY_GENERATOR,0))
will set MY_GENERATOR to NEW_VALUE (if I didn't screw this up!).
However, one should think twice before manipulating generator values ...


Regards,
Aage J.