Oninit cdi / Archive
Talk to an expert →

ENC: Drop tables with CDR enable

Posted in 2004

Topics: High Availability & Replication, Platform-Specific Issues, Versions, Editions & End-of-Life

Julio Cesar — — source: Usenet: comp.databases.informix

Is there a way to process 'drop table' sqls on tables configured to Enterprise Replication? If there isn't, how can I bypass these sqls? IDS 7.31-UD1 RedHat Linux 7.3 Best regards, Julio --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.558 / Virus Database: 350 - Release Date: 2/1/2004 sending to informix-list

↪ replying to Julio Cesar
Madison Pruet — — source: Usenet: comp.databases.informix

You need to first remove the participant's table from replication via the "cdr change replicate -d" command. M.P. "Julio Cesar" <julio@prodesmaq.com.br> wrote in message news:btjvg5$514$1@terabinaries.xmission.com... > > Is there a way to process "drop table" sqls on tables configured to > Enterprise Replication? > If there isn't, how can I bypass these sqls? > > IDS 7.31-UD1 > RedHat Linux 7.3 > > Best regards, > Julio > > --- > Outgoing mail is certified Virus Free. > Checked by AVG anti-virus system (http://www.grisoft.com). > Version: 6.0.558 / Virus Database: 350 - Release Date: 2/1/2004 > > > > sending to informix-list

Glossary