Re: Q: easy: changing serial value manually

Luis Miguel Agudelo Jimenez wrote: > > This is the point 5.9 of the FAQ'S: > > 5.9 How to alter the next SERIAL number > > Jonathan Leffler (johnl@informix.com) #include : > > To change the next inserted serial number to a value greater than its > current value you can: > [SNIP] > } I've checked all my manuals and I can't seem to get the syntax down. > } This is accepted but doesn't work: > } > } alter table employee > } modify employeeno serial(579) > } > } (I'm trying to change it to 579 - there are no values higher than this). Once again here is an easy way. If I understand you, you want to make sure that the next record has a serial number >= 579 since it is the highest number? Then just insert a record with a serial number of 579. It will automatically set the serial number to that value. For a better description of how serial numbers work, see an article I posted earlier. (Use dejanews) -Mikey