Re: SQL Question

[rob@xxxxxxxxx]

Goes back to the old saying, "Given enough time and money we can solve any 
problem".

Straight SQL doesn't really support CONNECTing to multiple systems at the 
same time.  You can RTM on CONNECT for further information.

IBM has a product, "Websphere database integrator", I believe, that 
supposedly does this.  Just requires that you pay through the nose (and a 
few other orifices) and pipe your data through a PC.  Because at several 
thousands of dollars a pop it's just not cost effective to port this code 
to a real computer and bypass the intermediary (sarcasm intended).

IBM also has a straight LPP called SMP for Symmetric Multi Processor, or 
some such thing, that 'may' help.  It has some other side benefits that 
may help you.  Like the stockbroker says, "Read the prospectus carefully 
before buying".

There are several third party products that are quite cool for data 
replication.  Mimix and others.

Rob Berendt