RE: ER and row_id

Posted in 2005

Mike Badar — Wed, 21 Sep 2005 10:57:09 -0600 — source: Usenet: comp.databases.informix

Thank you Andreas. This is the information I was looking for. Mike > -----Original Message----- > From: owner-informix-list@iiug.org > [mailto:owner-informix-list@iiug.org] On Behalf Of Andreas Legner > Sent: Tuesday, September 20, 2005 3:27 PM > To: informix-list@iiug.org > Subject: Re: ER and row_id > > That is exactly what CDR_SERIAL is meant for :-) > > Mike Badar wrote: > > > Greetings, > > > > Is it possible to maintain unique row_id's across 3 nodes > using ER? One > > idea I have is to use a SERIAL column registered as USER > maintained for > > their ROW_ID; the idea would be to use the CDR_SERIAL > parameter on each > > node with a different offset and delta to ensure uniqueness. > > Suggestions? Criticism's? > > > > Mike Badar > > ESRI-Denver > > 1 International Court > > Broomfield, CO 80021-3200 > > 303-449-7779 > > mbadar@esri.com > > www.esri.com > > sending to informix-list sending to informix-list