Re: sql server -> informix

OK I created a table 'test_rbv' with three columns col1, col2, col3. col1 is serial, col2 and col3 CHAR. Ran the following SQL Statements: insert into test_rbv(col2, col3) VALUES ('rob','vorbroker'); insert into test_rbv(col2, col3) VALUES ('john','doe'); Ran 'select * from test_rbv' and got the following results: col1 col2 col3 1 rob vorbroker 2 john doe Looks like it already works as is. At least on a SUN box with IDS v9.30 Rob Vorbroker > > 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.

On Wed, 11 Jun 2003 16:41:29 -0400 (EDT), Rob Vorbroker <robv@dns1.vcicentral.com> wrote: Same here -- IDS 9.30 on HPUX11i. > >OK I created a table 'test_rbv' with three columns col1, col2, col3. col1 >is serial, col2 and col3 CHAR. Ran the following SQL Statements: >insert into test_rbv(col2, col3) VALUES ('rob','vorbroker'); >insert into test_rbv(col2, col3) VALUES ('john','doe');> >Ran 'select * from test_rbv' and got the following results: > > col1 col2 col3 > > 1 rob vorbroker > 2 john doe > >Looks like it already works as is. At least on a SUN box with IDS v9.30 > >Rob Vorbroker >> >> 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. > >