Re: Changing serial value

I don't really have any new ideas to add to the solutions, but wondered if anyone else had encountered the following problem and had a solution to it. A header table uses a serial column for it's key. The detail table uses this key to join it to the header. Now what do you do if you must unload some rows from the 2 tables and insert them into a new database? In many cases, you will NOT be able to re-use the same serial keys for the header table as they are potentially already in use by the database you wish to load them into. I suppose we could write a program to do this, but I was wondering if there were any easier way. marko kopac wrote: > I don't know how to change a serial value in a table (Informix > database). I need this to copy a record to the same table. First I > copy > a record to a temp table. There I try to change the serial value and > then to insert to the original table. This is my idea. Has anybody > some > another idea hove to solve this problem? > > Marko -- - Danny Wright danwright@bigfoot.com #include <stddisclaimers.h> * God is real, unless declared as an integer. * Why do programmers get Halloween and Christmas mixed up? Because 0CT(31) == DEC(25) * I'd love to change the world, but I can't get into the source code. * /nev/dull