Re: 7.2 talking to 8.2
Istar did go away in version 6 as a seperate product. Effectively it was
implemented into the engine as you said. The terminology is sometimes still
used however in reference to remote database connectivity.
The original posting refered to the ability to directly access an 8.2 table
from a stored procedure running in a 7.x engine.
The following is from a reply message that I sent directly to another
individual. Maybe it will explain better what I am saying in relation to
the original posting.
If you have two instances (I'll call them informix1 and informix2) they
might be on the same machine or two different machines it doesn't matter.
Normally (with 7.x) you can connect to informix1 and execute a statement as
follows:
select * from sysmaster@informix2:systables;
This might be referred to as a distributed or remote query.
Now, if either informix1 or informix2 (or both) are 8.x servers, the same
query will fail because distributed query capability (sometimes referred to
as istar) is not yet available with 8.x.
My original statement that this feature will be available in 8.3 is not
completely accurate. As luck would have it, I had the opportunity to meet
with the VP of development for datawarehousing products with Informix this
week. I asked him about this same topic. He indicated that istar will only
be partially implemented in 8.3 (which they are now calling Yellowstone) it
will be available around September of this year, it probably won't be fully
implemented until 8.4 (Independence), which they are targeting for spring of
2000.
Essentially what this means is that with 8.x you can only access data within
the same instance and you can't access 8.x data from an outside instance.
I hope this helps.
If I am inaccurate please correct me, but I know that I can't execute such a
query with my 8.21 instances.
-----Original Message-----
From: Mark D. Stock <mdstock@informix.com>
To: Steve Wenzbauer <steve.wenzbauer@gte.net>
Cc: informix-list@iiug.org <informix-list@iiug.org>
Date: Thursday, March 11, 1999 5:29 AM
Subject: Re: 7.2 talking to 8.2
>Steve Wenzbauer wrote:
>>
>> I'd be surprised if it worked currently. To my knowledge istar is not
yet
>> implemented in 8.2. I'm working with 8.21.UD2, and remote database
>> connections are not allowed. I believe it is supposed to be implemented
in
>> 8.3.
>
>I am confused by your statements. Istar disappeared in version 6. All
>versions of IDS since then have been network ready. You just need to set
>up the appropriate protocols.
>
>But then maybe you are not talking about Informix products.
>
>> minek@hotmail.com wrote in message <7c1ciq$nej$1@nnrp1.dejanews.com>...
>> >Does anybody know about any potential problems
>> >with a stored procedure being executed on Informix Online
>> >Server 7.2 and selecting some data from another remote server
>> >(version 8.2 (data warehouse)) ?
>> >
>> >It works, but I'd like to know, if it's going to work after
>> >servers are upgraded.
>> >I hope that protocol Informix uses for this kind of communication
>> >will remain the same in the future, regardless of the server version.
>> >Any info will be appreciated.
>
>I can think of no reason why this should not continue to work. But
>that's no guarantee.
>
>Cheers,
>--
>Mark.
>
>+----------------------------------------------------------+-----------+
>|Mark D. Stock - Informix SA http://www.informix.com |//////// /|
>|mailto:mdstock@informix.com http://www.informix.com/idn |///// / //|
>|http://www.iiug.org +-----------------------------------+//// / ///|
>| Tel: +27 11 807 0313 |If it's slow, the users complain. |/// / ////|
>| Fax: +27 838250 2325 |If it's fast, the users keep quiet.|// / /////|
>|Cell: +27 83 250 2325 |Therefore, "No news: travels fast"!|/ ////////|
>+----------------------+-----------------------------------+-----------+
>