Create autoserial column in informix
alter table my_table add id integer before some_field; create sequence myseq; update my_table set id = myseq.nextval; drop sequence myseq; alter table my_table modify (id serial not null);