Re: sql server -> informix

I know that if you insert a zero in the serial column it will automatically be assigned the next value. insert into table_a values(0,field_2,field_3) Rob Vorbroker > We are about to port an application from SQL Server to Informix. > In SQL Server, identity column (equivalent of serial) is always > the first column. This gives the developers an advantage of skipping the > first column (if it is identity) and SQL server will automatically > assign the next higher number during an insert. > > So we have inserts like > insert into table_a values(field_2,field_3).> > In this case field_1 is an identity field and gets value automatically. > > Can this code work in Informix. Is there a way around, though I don't > think so.