Re: newbie - autoincrement data type

Hi, Your looking for SERIAL. Bill } } Hi, } } There doesn't appear to be a FAQ and the Informix documentation doesn't } mention it, but I'm hoping there is some type of field that automatically } increments itself, something like.... } } create table mytable } ( } ID integer not null, autoincrement??? } last_name varchar(50,0) not null } ); } } } Any help would be much appreciated, } } Paul } } } -- Bill Ennis Voice: 312-474-7516 SSA Fax: 312-474-7460 500 W. Madison email: ennis@ssax.com