Re: ER between two databases in the same instance

Seems to me that it should be something that is available. I'm sure that there is a good reason why it is not but I would have assumed that it could be done if I did not no better. If available I'm sure that lots of folks would find a user for it although I cannot say that I, presonally, have one right now. --- Madison Pruet <mpruet@comcast.net> wrote: > 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

Hi, in this very special case is there anything wrong with creating a synonym for the table in the other database (or a view) ? What would be the disadvantage? Cheers, Dirk -- -- Dirk Gunsthoevel IT Systemanalyse phone: +49 (0)251 28446-0 -- Hammer Str. 13 fax: +49 (0)251 28446-55 -- D-48153 Muenster http://www.GunCon.de/ -- "Toto, I don't think we're in Kansas anymore..." "DL Redden" <redden96@yahoo.com> schrieb im Newsbeitrag news:1126222678.d5a1ec96fcc918ab5830491a9bd1bde7@teranews... > > Seems to me that it should be something that is > available. I'm sure that there is a good reason why it > is not but I would have assumed that it could be done > if I did not no better. If available I'm sure that > lots of folks would find a user for it although I > cannot say that I, presonally, have one right now. > > --- Madison Pruet <mpruet@comcast.net> wrote: > > > 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