Developer needs advice from Informix guru 
Author Message
 Developer needs advice from Informix guru

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

Quote:
-----Original Message-----

Sent: Tuesday, October 02, 2001 12:21 PM

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

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



Sun, 21 Mar 2004 01:22:59 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. Developer needs advice from Infromix guru

2. Guru Advice Needed for Query on Interesting Data Scenario

3. SQL Server Guru urgently needed for setup advice

4. guru advice needed on temporary table problem

5. Guru advice needed:16-bit app crashes Windows.

6. Guru's advice needed on dbms_job related question

7. Web Server Gurus...Advice Needed !!!

8. In Need of FileMaker Guru for advice on complex Date/Time calculation

9. Need advice from a database guru

10. Happy New Year Visual Basic Gurus- Developers needed nationwide-(Recruiter)

11. Need Informix guru's

12. INFORMIX GURU NEEDED


 
Powered by phpBB® Forum Software