SERIAL DATA TYPE

F> From: finnan@sse.ie (Enda Finnan) F> Does anyone if their is a mechanism or workaround to get the SERIAL > datatype to wrap back to 1 (or some other value) when it reaches its > maximum (2147483647)? Informix will automatically wrap around and re-use serial values which are not in the table. So, as long as you delete rows, they theoretically will eventually be reused. I say theoretically, because most people find that they will be retired before they will have to worry about that! 8-) Tim --- ~ SPEED 1.40 [NR] ~