Re: Replication

Edward Villalovoz wrote: > > Does anyone know what the best way to check one table in an informix > database, compare it with a table in another informix database, and if there > is new data in the first table, append only the new data to the second > table? And I need to do this from perl. If you have any sample code it > would be helpful. :) Thanks in advance. Jonathan Leffler is writing an "updater" which will be able to either update a row in table 2 from a select statement's result set or a file if the row exists or insert it if it does not exist. Unfortunately this utility is being written in ESQL/C. Perhaps if you asked REALLY nicely, since Jonathan developed the DBD, he might be willing to port the logic to a perl program. Personally I prefer a compiled executable but... Art S. Kagel