Re: How do I use 2 DB at once?

It works from one host to another with network connection!!! If you can reach the system from OS, then both having An Informix DB, set up your OS service and Informix sqlhost files. Create synonyms or fully qualify table names and you will be able to access the data. If you need to reach an Informix DB that is Informix 5.x you will need I-Star. Both must be in the same logging state. That is a non-logging DB cannot reach a logging DB..... I am wondering if A PC DB created in 6.X Informix SE can access a DB created in 7.X Informix Online, if so, how in detail? I have heard that the "CONNECT" statement is not available on a 6.X SE that resides on a PC. If the connection is made, it bums me why the two cannot talk, if you have everything set up(that detail on the SE side I'm missing). ------------------------------------------------------------------------- Cheryl Kendricks Internet:cherylk@prod1.jcdc.doleta.gov OR cherylk@gwysmtp.jcdc.doleta.gov DTSI, Inc. Voice: 1-800-598-5008 Fax: 512-393-7296 Database Administrator - DOL Job Corps San Marcos, Texas ------------------------------------------------------------------------ On Fri, 7 Jun 1996, M Kevin McHugh wrote: } Joel Schumacher wrote: } > } > I'm using Online 7.x with 6.x tools. } > } > Database AAA exists on machine alpha. Database BBB exists on machine beta. } > } > My application runs on machine alpha and has database AAA open. It needs } > to get data from database BBB on machine beta, without closing the database. } > snip } > I'm trying to look at statements like CONNECT, SET CONNECTION, } > DISCONNECT, etc. Has anybody looked at these? Can you give me some tips } > on how to use them? } >snip } } Joel, } I am reading "Informix Guide to SQL, Syntax Version 6.0". It may or may } not be the most up to date, but it works Ok for me. Anyhow, on pages 1-44 } through 1-54, this manual describes the CONNECT statement. It goes into } gory detail on the CONNECT ... WITH CONCURRENT TRANSACTION uses. It points } out that Informix does not support "global" transactions. However, I am sure } that you could code such a thing correctly with a little logic in C. This } concurrent transaction lets you switch between database connections without } dropping a transaction that you are already in. It seems pretty handy for } addressing your question. I tried it out some months ago and it works. } ( Informix 7.10.UC1 ) I have NOT tried to go to 2 different machines. Give } it a try and let me know if it works. } } I hope this helps, } Kevin } -- } +------------------------------+-------------------------+----------------+ } | Kevin McHugh - SW Engineer | mkmchu@fax.cs.mci.com | } | MCI Telecommunications Corp. | (719) 535-5278 | } +------------------------------+-------------------------+----------------+ } | ALL RIGHTS RESERVED. | } | This posting is copyright and may be used only for the purposes | } | of professional study. Use of this posting in any commercial | } | environment is explicitly prohibited. This posting may only be | } | reproduced for personal archival purposes. | } +-------------------------------------------------------------------------+ }