Oninit cdi / Archive
Talk to an expert →

Re: Informix 7.2SE

Posted in 1999

Topics: Migration, Import/Export & Data Conversion

Sujit.Pal@BankAmerica.com — — source: Informix-list mailing list archive (1991-1998)

Michael If you specify a column value of 0 (or dont specify it in the list of columns you are inserting to), then the serial column will be populated with an "auto-number". If you specify the value of the serial column in your insert statement, it will be used. I dont know what will happen if you decide to enter the same value again and again, but in my case, most serial fields in the database are also primary keys with a unique index so thats not a possibility for me. HTH Sujit Michael Muir-Browe <Michael@nospam.truecs.force9.co.uk> on 04/07/99 12:59:46 AM Please respond to Michael Muir-Browe <Michael@nospam.truecs.force9.co.uk> To: informix-list@iiug.org cc: (bcc: Sujit Pal) Subject: Informix 7.2SE Hi, i need to transfer some data into a table with a serial as the primary key. This in turn is used as the FK in another table. Is there any way to insert data into the table and turn the serial facility off until it is complete. Reason:- I have changed the table structure and therfore cannot use load/unload, unless of course you know diffrenet. best regards Michael

↪ replying to Sujit.Pal@BankAmerica.com
Michael Muir-Browe — — source: Informix-list mailing list archive (1991-1998)

thanks <Sujit.Pal@BankAmerica.com> wrote in message news:7eg3rd$m4a$1@news.xmission.com... > > > > Michael > > If you specify a column value of 0 (or dont specify it in the list of > columns you are inserting to), then the serial column will be populated > with an "auto-number". If you specify the value of the serial column in > your insert statement, it will be used. I dont know what will happen if you > decide to enter the same value again and again, but in my case, most serial > fields in the database are also primary keys with a unique index so thats > not a possibility for me. > > HTH > > Sujit > > > > > > Michael Muir-Browe <Michael@nospam.truecs.force9.co.uk> on 04/07/99 > 12:59:46 AM > > Please respond to Michael Muir-Browe <Michael@nospam.truecs.force9.co.uk> > > To: informix-list@iiug.org > cc: (bcc: Sujit Pal) > Subject: Informix 7.2SE > > > > > Hi, > > i need to transfer some data into a table with a serial as the primary key. > This in turn is used as the FK in another table. > > Is there any way to insert data into the table and turn the serial facility > off until it is complete. > > > Reason:- > > I have changed the table structure and therfore cannot use load/unload, > unless of course you know diffrenet. > > best regards > > Michael > > > > > > > >