If the user was wanting a real-time copy that could be
modified without affecting the source then synoyms or
views would cause issues. Although I guess modifying
the target could pose update conflicts so even that
may not be a great idea.
--- Dirk Gunsthvvel <dirk@guncon.de> wrote:
> 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
sending to informix-list