Re: About serial type

Manel Falc' wrote: > > Hi all, > Using serial type is a good way to assign an unique key to any table > and simplify the selects and joins. > But when there are more than one machine and you have to transfer > information between them, there is a problem: Every machine has the > same tables but their own serial numbers, so, the use of serial is > not valid in this case. > Even initializing the serial field to different numerations for every > table and machine could be a problem: it's only an integer field. > What to do in this case ? > What about "replication" ? I don't know whether informix has any > solution about ... > > Thanks a lot, > > Manel Falc' > SEMIC, S.A. > Lleida-Catalonia-Spain-Europe > ----------------------------------------------------- > Informix version: Informix SE 5.07 / RDS 4.x & 4J's > Operating system: Unix SCO V 5.04 > ----------------------------------------------------- Could you add a column to the primary key which contains something unique to each machine? -- Peter Lancashire Information Systems Specialist, Bayer plc Eastern Way, Bury St Edmunds, Suffolk, IP32 7AH, UK Tel: +44-1635-562258, Fax: +44-1635-562281 --- If all else fails, read the instructions and the release notes. Join Infuse, the UK Informix User Group at http://www.infuse.org.uk/ ---