RE: ER between two databases in the same instance

Some people might disagree with me, but it would be nice to have, even if just for marketing purposes. Imagine someone asking this question when comparing databases. Can your database do this ? It just makes the database so much more flexible. Question is, can Oracle do this ? Need to compete with the others ... -----Original Message----- From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org] On Behalf Of Madison Pruet Sent: 08 September 2005 08:27 PM To: informix-list@iiug.org Subject: Re: ER between two databases in the same instance Question for the group as a whole... How important is this functionality? "cristizaharioiu" <cristizaharioiu@gmail.com> wrote in message news:1125990751.160483.46740@g14g2000cwa.googlegroups.com... > Hello, > > Can I define a replicate for a table between two databases in the same > instance (the same group) ? > > Here is the replicate : > > cdr define repl -C ignore --scope=transaction --immed --ats --ris > r_tabela_test "P bd_test_1@g_scot79:informix.tabela_test" "select * > from tabela_test " "R bd_test_2@g_scot79:informix.tabela_test" > "select * from tabela_test" > > I tried to define it and I got next error : command failed -- duplicate > server or replicate (53) > participant bd_sco79@g_scot79:informix.tabela_test 'select * from > tabela_test '. > > The replicate is not duplicate only server could be. > > The medium is IDS 10 & Suse Sles 9. sending to informix-list

"Dirk Moolman" <DirkM@caretech.co.za> wrote in message news:1126282330.055c5803673ac8591640e3ad28f74182@teranews... > > Some people might disagree with me, but it would be nice to have, even > if just for marketing purposes. Imagine someone asking this question > when comparing databases. Can your database do this ? It just makes > the database so much more flexible. > > Question is, can Oracle do this ? Need to compete with the others ... > Well --- maybe. The real question would be is "Does this functionality increase sales and/or address customer needs. And if it does, then what is the need that it addresses.". I mean Oracle might implement a function called callGeorgeBushWhenTransactionAborts(). Well - I don't think that we'd implement such a functionality just because Oracle did. ;-) I can see one need for replicating to the same instance because I could have additional triggers on the target table which could fire. But instead of implementing replication to myself to support that functionality, it'd probably make more sense to simply implement post-commit triggers. That's why I'm trying to understand the reason for this request. Thanks. M.P. > > -----Original Message----- > From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org] > On Behalf Of Madison Pruet > Sent: 08 September 2005 08:27 PM > To: informix-list@iiug.org > Subject: Re: ER between two databases in the same instance > > Question for the group as a whole... How important is this > functionality? > > "cristizaharioiu" <cristizaharioiu@gmail.com> wrote in message > news:1125990751.160483.46740@g14g2000cwa.googlegroups.com... > > Hello, > > > > Can I define a replicate for a table between two databases in the same > > instance (the same group) ? > > > > Here is the replicate : > > > > cdr define repl -C ignore --scope=transaction --immed --ats --ris > > r_tabela_test "P bd_test_1@g_scot79:informix.tabela_test" "select * > > from tabela_test " "R bd_test_2@g_scot79:informix.tabela_test" > > "select * from tabela_test" > > > > I tried to define it and I got next error : command failed -- > duplicate > > server or replicate (53) > > participant bd_sco79@g_scot79:informix.tabela_test 'select * from > > tabela_test '. > > > > The replicate is not duplicate only server could be. > > > > The medium is IDS 10 & Suse Sles 9. > sending to informix-list