Adam wrote:

> It is a big number, 2,147,483,648 to be precise. I doubt you would
> ever hit it.
>
> If it really worries you define it as a bigint, then you get
> 9,223,372,036,854,775,808 which is most likely more than the number of
> generator values your server could produce before the sun used up all
> its hydrogen and imploded.

And if that's not enough (database app. used on SS Enterprise), you can
always use two or more generators. Something like:

gen1 = gen_id(gen1_name, 1);
if (gen1 = 0)
gen2 = gen_id(gen2_name, 1);
else
gen2 = gen_id(gen2_name, 0);

name = 'temp_table_name_' || gen1 || '_' || gen2;


--
Milan Babuskov
http://fbexport.sourceforge.net
http://www.flamerobin.org