Path: utzoo!attcan!uunet!uvm-gen!matrox!cmtl01!mdorion
From: mdorion@cmtl01.UUCP (Mario Dorion)
Newsgroups: comp.databases
Subject: Hot to reset a 'serial' field in informix table
Message-ID: <225@cmtl01.UUCP>
Date: 9 Jan 89 16:28:43 GMT
Organization: Xios Systems, Montreal, Canada
Lines: 24


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