[comp.databases] Hot to reset a 'serial' field in informix table

mdorion@cmtl01.UUCP (Mario Dorion) (01/10/89)

Hi!

One of my customers is playing with a big ( ~ 90000 records ) database managed
by Informix 2.10.00A on a Tower 32 mini.

One of the fields is a 'serial#' type of field. When that database was set up
we assigned an initial value of 880000 to that field since we wanted the first
2 digits to reflect the year the record was entered into the system.

Now guess what?

I'd like to set a new initial value of 890000. The Informix manuals aren't 
helping a bit here.

How should I do it?

Thanking all in advance.

-- 
     Mario Dorion          | E-mail: mdorion@x02.UUCP 
     XIOS Systems          |         ...uunet!attcan!cmtl01!x02!mdorion
     Montreal, Canada      |
     1 (514) 744-3410      |"All the young dudes carry the news ..." - Bowie