Oninit cdi / Archive
Talk to an expert →

Re: Informix 7.2SE

Posted in 1999

Topics: Migration, Import/Export & Data Conversion

Obnoxio The Clown — — source: Informix-list mailing list archive (1991-1998)

>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. I know different. I used to go to school with him. :-) If you're loading into a table where those serial keys don't already exist, you should have no problems inserting the data. The serial number will only be generated if you insert a 0 (zero) into the serial field, if you insert a number and the number doesn't exist, it will accept it. HTH. -- "I'll Be Back" Obnoxio ************************************************ Sane? Hell, if I was sane, why would I be here? ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com

↪ replying to Obnoxio The Clown
Michael Muir-Browe — — source: Informix-list mailing list archive (1991-1998)

thanks Obnoxio The Clown <obnoxio@hotmail.com> wrote in message news:7efb7m$dj3$1@news.xmission.com... > > >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. > > I know different. I used to go to school with him. :-) > > If you're loading into a table where those serial keys don't already > exist, you should have no problems inserting the data. The serial > number will only be generated if you insert a 0 (zero) into the serial > field, if you insert a number and the number doesn't exist, it will > accept it. > > HTH. > > -- > "I'll Be Back" > Obnoxio > > ************************************************ > Sane? Hell, if I was sane, why would I be here? > > > > ______________________________________________________ > Get Your Private, Free Email at http://www.hotmail.com