Re: sql server -> informix

Hi Ravi, I don't think this code is going to work in Informix ... u'll have to replace field_1 with 0 (zero) in order to have the same functionality. I think probably it won't be a bad idea to put this as a feature request in our next releases....:-) Thanx much, Rajib Sarkar Advisory Support Engineer IBM Data Management Solutions Ph: 602-217-2100 As long as you derive inner help and comfort from anything, keep it -- Mahatma Gandhi Wednesday, June 11, 2003 9:17 AM To: informix-list@iiug.org cc: From: "rkusenet" <rkusenet@sympatico.ca> Subject: sql server -> informix 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.