Re: sql server -> informix

While I appreciate your desire to make as few code changes as possible this does not appear to be a huge change. Also you certainly don't expect to migrate from one DB platform to another without incurring some relative 'pain' do you? Best of luck with your endeavor. Rob Vorbroker > > "Arthur Groen" <arthur@hiljo.nl> wrote in message > news:bc7iin$4u0$1@terabinaries.xmission.com... >> >> Insert a 0 (zero) for the serial value and informix will asign the >> next serail the it. >> >> insert into table_a values(0, field_2,field_3).>> >> You can read the value back with >> Let F_serail = SQLCA.SQLERRD[2] > > This is not what I asked. > I wanted to know whether it is possible to entirely omit the serial > field in the values section and still get serial inserted. This way I > don't have to change code. > > Well the answer is it is possible using views. But even that would mean > a code change.