Hi Jason,

Thanks for the tips about using gen_id( ,0).
Anyway I'm just curious where the *IB Server* store the last value of the
generator. I guess your tips means it doesn't expose it to any system
tables then (like the way Oracle does in USER_SEQUENCES view).

thanks & regards,
Sindu

On Mon, 19 Mar 2001, Jason Wharton wrote:

> You get the current value of a generator by calling GEN_ID( <gen-name>, 0 ).
> Incrementing by zero doesn't actually change its value and returns the
> current value.
>
> You can't actually delete the generator itself. You can delete the record in
> the system table that indicates its existance but the space it takes is not
> reclaimable until after a backup and restore.
>
> HTH,
> Jason Wharton
> CPS - Mesa AZ
> http://www.ibobjects.com