Developer needs advice from Informix guru

[Martin, Wayne E.]

We used this under 9.21, no problems.

The two servers were on private 100 M/bit net work.

Wayne E Martin
Informix Database Administrator
Kmart Corporation

-----Original Message-----
From: cgre...@redtrain.com [mailto:cgre...@redtrain.com]
Sent: Tuesday, October 02, 2001 12:21 PM
To: inform...@iiug.org
Subject: Developer needs advice from Infromix guru

I am developing a batch job using transactions that span databases on
two different servers. My plan was to use remote synonyms and write
the job as a stored procedure, but the DBAs fear that remote synonyms
may take down the target server, is anyone aware of this as a problem
(v7.31)?

Their suggestion is to reference the remote tables with explicit path
information (i.e. database@server:table). Problem with that is I
don't want to hard code environment specific information into a
procedure that has to live in dev, qa, and prod environments. Is
there any way to make this dynamic within the procedure? Also, will
begin/rollback/commit work within this procedure given that part of
the transaction will be remote?

TIA - Chris