Re: Sequences in Illustr/Informix
On 6 Jan 97 at 13:29, Trevor A. Phipps wrote:
> 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.
In Informix you say
CREATE TABLE x (
serno SERIAL(20),
.
.
.
);
serno will then be an auto-incrementing 4-byte integer which starts
at 20 and increments by 1. I have never found a way of changing the
increment.
HTH.
--
Ciao,
Billy
I'd be in favour of apathy, but I just couldn't be bothered...