Re: Serial Data type

}>>>>>>>>> Perry's response to Malcolm Weallans <<<<<<<<<< When the column hits the max, informix will roll it over to the next available number for you. If that's not what you want, you could write a trigger that will inform you when you are getting close to the max. number. } From: onlinedbc@cix.compulink.co.uk ("Malcolm Weallans") } Subject: Re: Serial Data type } Date: Mon, 12 Jun 1995 17:37:25 GMT } To: informix-list@rmy.emory.edu } } > } > What should I do if I want to roll over a serial data type? } > i,e: I've a table that I'll doing 6000 inserts daily. 1 mo later } I'll > deletes these rows, but the serial col will keep incrementing. } What > should I do when the col. hits max? } > } By my calculations you have a few hundred years to work it out. } Are you bothered? } } } Malcolm Weallans } Online Database Consultancy } Phone 0628-72154 } Fax 0628-37463 } CIX - onlinedbc } -perryd (Guru) ==================================================================== = Perry Dillard - CASE Tools Development Team Leader = = FourGen Software, Inc. = = FourGen Building = = 115 NE 100th Street = = Seattle, W.A. 98125-8098 e-mail: perryd@fourgen.com = ====================================================================