Re: Sequences in Illustr/Informix

Trevor A. Phipps wrote: > > ------------4B946A68A00 > Content-Transfer-Encoding: 7bit > Content-Type: text/plain; charset=us-ascii > > Does ILLUSTRA/INFORMIX have a sequence structure, (ie) some structure > for automatically assigning unique numbers without creating a special > table and routines to handle updates to that table. > > In ORACLE it is handled as follows > CREATE SEQUENCE seqname increment by 1 start with 20. Informix has SERIAL datatypes which are integers that will auto increment. I believe that if you populate the column initially, that will act as the "start with" value. Normally, you add the value as a 0 when you insert a row. Check the serial datatype in the manual. Vic -- Victor Goldberg Cornell Theory Center vic@tc.cornell.edu