How tu use a table on another Instance
A user with an HDR pair (servers x/y) wanted to read a table living on a third, separate IDS instance (z) from server y. The answer: use a distributed query with fully qualified naming, e.g. select ... from database@instance_z:table, provided instance_z is listed in y's sqlhosts and trust is set up (hosts.equiv/.rhosts); test connectivity first with dbaccess database@instance_z. A server alias on z was also suggested. A side discussion noted that distributed queries are licence-prohibited on Growth/Workgroup/Innovator/Express editions (per IBM licence documents, with ER replication as a workaround), but the poster had the Ultimate edition, so the straightforward distributed query applied.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
Hi, I have my instance (11.50) "x" replicated with hdr "y", i made a third ids server "z" that contains a table which i want to acces from the "y" server, so what are the steps to do so, please ? thanks in advance
Hi,
you should be able to query the table using the syntax
select field1, field2 ... from database@instance_z:table ...If the instance_z is in your sqlhosts of instance y and z trusts y
(hosts.equiv or .rhosts e.g).
Direct access can be tested with dbaccess (dbaccess database@instance_z should
work directly
from y machine).
Marcus
----- Ursprüngliche Mail -----
Von: "SMITH JOHN" <daylight@webmails.com>
An: ids@iiug.org
Gesendet: Montag, 27. Mai 2013 21:22:31
Betreff: How tu use a table on another Instance [30348]
Hi,
I have my instance (11.50) "x" replicated with hdr "y", i made a third ids
server "z" that contains a table which i want to acces from the "y" server, so
what are the steps to do so, please ?
thanks in advance
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
The only caviat is that only enterprise edition supports distributed
queries!
The alternative, if you are using Growth/Workgroup Edition, Innovator
Edition, or Express Edition, would be to use ER to replicate the table to
the HDR pair.
Art
On May 27, 2013 4:03 PM, "Marcus Haarmann" <marcus.haarmann@midoco.de>
wrote:
> Hi,
>
> you should be able to query the table using the syntax
> select field1, field2 ... from database@instance_z:table ...> If the instance_z is in your sqlhosts of instance y and z trusts y
> (hosts.equiv or .rhosts e.g).
> Direct access can be tested with dbaccess (dbaccess database@instance_zshould
> work directly
> from y machine).
>
> Marcus
>
> ----- Ursprüngliche Mail -----
>
> Von: "SMITH JOHN" <daylight@webmails.com>
> An: ids@iiug.org
> Gesendet: Montag, 27. Mai 2013 21:22:31
> Betreff: How tu use a table on another Instance [30348]
>
> Hi,
>
> I have my instance (11.50) "x" replicated with hdr "y", i made a third ids
> server "z" that contains a table which i want to acces from the "y"
> server, so
> what are the steps to do so, please ?
>
> thanks in advance
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--089e0117749dac969404ddb9851a
i forgot to tell that i have the ultimate version :)
Also, you could create as alias on server z
Sent from my iPad
On May 27, 2013, at 3:04 PM, "Marcus Haarmann" <marcus.haarmann@midoco.=
de>
wrote:
> Hi,
>
> you should be able to query the table using the syntax
> select field1, field2 ... from database@instance_z:table ...> If the instance_z is in your sqlhosts of instance y and z trusts y
> (hosts.equiv or .rhosts e.g).
> Direct access can be tested with dbaccess (dbaccess database@instance=
_z
should
> work directly
> from y machine).
>
> Marcus
>
> ----- Urspr=FCngliche Mail -----
>
> Von: "SMITH JOHN" <daylight@webmails.com>
> An: ids@iiug.org
> Gesendet: Montag, 27. Mai 2013 21:22:31
> Betreff: How tu use a table on another Instance [30348]
>
> Hi,
>
> I have my instance (11.50) "x" replicated with hdr "y", i made a thir=
d
ids
> server "z" that contains a table which i want to acces from the "y"
server, so
> what are the steps to do so, please ?
>
> thanks in advance
>
>
>
***********************************************************************=
********
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
>
***********************************************************************=
********
> Forum Note: Use "Reply" to post a response in the discussion forum.=
>=
Hmmm you sure are about that
On my workgroup 11.70
Select *
From oninit@theoden:users a, oninit@gimli:users b, custdb@custsite:users c
Where a.uid = b.uid
And a.uid = c.uid
Works happenly
Cheers
Paul
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Art
Kagel
Sent: Monday, May 27, 2013 4:07 PM
To: ids@iiug.org
Subject: Re: How tu use a table on another Instance [30350]
The only caviat is that only enterprise edition supports distributed
queries!
The alternative, if you are using Growth/Workgroup Edition, Innovator
Edition, or Express Edition, would be to use ER to replicate the table to
the HDR pair.
Art
On May 27, 2013 4:03 PM, "Marcus Haarmann" <marcus.haarmann@midoco.de>
wrote:
> Hi,
>
> you should be able to query the table using the syntax
> select field1, field2 ... from database@instance_z:table ...> If the instance_z is in your sqlhosts of instance y and z trusts y
> (hosts.equiv or .rhosts e.g).
> Direct access can be tested with dbaccess (dbaccess
database@instance_zshould
> work directly
> from y machine).
>
> Marcus
>
> ----- Ursprüngliche Mail -----
>
> Von: "SMITH JOHN" <daylight@webmails.com>
> An: ids@iiug.org
> Gesendet: Montag, 27. Mai 2013 21:22:31
> Betreff: How tu use a table on another Instance [30348]
>
> Hi,
>
> I have my instance (11.50) "x" replicated with hdr "y", i made a third ids
> server "z" that contains a table which i want to acces from the "y"
> server, so
> what are the steps to do so, please ?
>
> thanks in advance
>
>
>
>
****************************************************************************
***
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
>
>
****************************************************************************
***
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--089e0117749dac969404ddb9851a
****************************************************************************
***
Forum Note: Use "Reply" to post a response in the discussion forum.
Cool. Then you are good to go. Art On May 27, 2013 5:24 PM, "SMITH JOHN" <daylight@webmails.com> wrote: > i forgot to tell that i have the ultimate version :) > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a11c33ffc930f1504ddba18dc
According to the edition feature list tgat Carlton put together it's not
supported/permitted.
Art
On May 27, 2013 5:25 PM, "Paul Watson" <paul@oninit.com> wrote:
> Hmmm you sure are about that
>
> On my workgroup 11.70
>
> Select *
> >From oninit@theoden:users a, oninit@gimli:users b, custdb@custsite:users> c
> Where a.uid = b.uid
> And a.uid = c.uid
>
> Works happenly
>
> Cheers
> Paul
>
> -----Original Message-----
> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Art
> Kagel
> Sent: Monday, May 27, 2013 4:07 PM
> To: ids@iiug.org
> Subject: Re: How tu use a table on another Instance [30350]
>
> The only caviat is that only enterprise edition supports distributed
> queries!
>
> The alternative, if you are using Growth/Workgroup Edition, Innovator
> Edition, or Express Edition, would be to use ER to replicate the table to
> the HDR pair.
>
> Art
> On May 27, 2013 4:03 PM, "Marcus Haarmann" <marcus.haarmann@midoco.de>
> wrote:
>
> > Hi,
> >
> > you should be able to query the table using the syntax
> > select field1, field2 ... from database@instance_z:table ...> > If the instance_z is in your sqlhosts of instance y and z trusts y
> > (hosts.equiv or .rhosts e.g).
> > Direct access can be tested with dbaccess (dbaccess
> database@instance_zshould
> > work directly
> > from y machine).
> >
> > Marcus
> >
> > ----- Ursprüngliche Mail -----
> >
> > Von: "SMITH JOHN" <daylight@webmails.com>
> > An: ids@iiug.org
> > Gesendet: Montag, 27. Mai 2013 21:22:31
> > Betreff: How tu use a table on another Instance [30348]
> >
> > Hi,
> >
> > I have my instance (11.50) "x" replicated with hdr "y", i made a third
> ids
>
> > server "z" that contains a table which i want to acces from the "y"
> > server, so
> > what are the steps to do so, please ?
> >
> > thanks in advance
> >
> >
> >
> >
>
> ****************************************************************************
> ***
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
> >
> >
>
> ****************************************************************************
> ***
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
>
> --089e0117749dac969404ddb9851a
>
>
> ****************************************************************************
> ***
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--001a11c33ffc5865b304ddba2281
Wow that has been a part of informix since forever - a show stopper for many I
should think
Cheers
Paul
Paul Watson
Oninit www.oninit.com
+1 913 387 7529
On May 27, 2013, at 16:50, "Art Kagel" <art.kagel@gmail.com> wrote:
> According to the edition feature list tgat Carlton put together it's not
> supported/permitted.
>
> Art
> On May 27, 2013 5:25 PM, "Paul Watson" <paul@oninit.com> wrote:
>
>> Hmmm you sure are about that
>>
>> On my workgroup 11.70
>>
>> Select *
>>> From oninit@theoden:users a, oninit@gimli:users b, custdb@custsite:users>> c
>> Where a.uid = b.uid
>> And a.uid = c.uid
>>
>> Works happenly
>>
>> Cheers
>> Paul
>>
>> -----Original Message-----
>> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Art
>> Kagel
>> Sent: Monday, May 27, 2013 4:07 PM
>> To: ids@iiug.org
>> Subject: Re: How tu use a table on another Instance [30350]
>>
>> The only caviat is that only enterprise edition supports distributed
>> queries!
>>
>> The alternative, if you are using Growth/Workgroup Edition, Innovator
>> Edition, or Express Edition, would be to use ER to replicate the table to
>> the HDR pair.
>>
>> Art
>> On May 27, 2013 4:03 PM, "Marcus Haarmann" <marcus.haarmann@midoco.de>
>> wrote:
>>
>>> Hi,
>>>
>>> you should be able to query the table using the syntax
>>> select field1, field2 ... from database@instance_z:table ...>>> If the instance_z is in your sqlhosts of instance y and z trusts y
>>> (hosts.equiv or .rhosts e.g).
>>> Direct access can be tested with dbaccess (dbaccess
>> database@instance_zshould
>>> work directly
>>> from y machine).
>>>
>>> Marcus
>>>
>>> ----- Ursprüngliche Mail -----
>>>
>>> Von: "SMITH JOHN" <daylight@webmails.com>
>>> An: ids@iiug.org
>>> Gesendet: Montag, 27. Mai 2013 21:22:31
>>> Betreff: How tu use a table on another Instance [30348]
>>>
>>> Hi,
>>>
>>> I have my instance (11.50) "x" replicated with hdr "y", i made a third
>> ids
>>
>>> server "z" that contains a table which i want to acces from the "y"
>>> server, so
>>> what are the steps to do so, please ?
>>>
>>> thanks in advance
>>
>> ****************************************************************************
>> ***
>>> Forum Note: Use "Reply" to post a response in the discussion forum.
>>
>> ****************************************************************************
>> ***
>>> Forum Note: Use "Reply" to post a response in the discussion forum.
>>
>> --089e0117749dac969404ddb9851a
>>
>>
>> ****************************************************************************
>> ***
>> Forum Note: Use "Reply" to post a response in the discussion forum.
>
*******************************************************************************
>> Forum Note: Use "Reply" to post a response in the discussion forum.
>
> --001a11c33ffc5865b304ddba2281
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
Aren't we confusing distributed queries and distributed/grid queries - the
later would need the ultimate/enterprise/whatever it is call this week version
AFAIK Marketing didn't like grid queries and called them distributed queries -
some thing that has always been there - nothing like presenting a clear image
:-)
Cheers
Paul
Paul Watson
Oninit www.oninit.com
+1 913 387 7529
On May 27, 2013, at 16:57, Paul Watson <paul@oninit.com> wrote:
> Wow that has been a part of informix since forever - a show stopper for many
I should think
>
> Cheers
> Paul
>
> Paul Watson
> Oninit www.oninit.com
> +1 913 387 7529
>
>
> On May 27, 2013, at 16:50, "Art Kagel" <art.kagel@gmail.com> wrote:
>
>> According to the edition feature list tgat Carlton put together it's not
>> supported/permitted.
>>
>> Art
>> On May 27, 2013 5:25 PM, "Paul Watson" <paul@oninit.com> wrote:
>>
>>> Hmmm you sure are about that
>>>
>>> On my workgroup 11.70
>>>
>>> Select *
>>>> From oninit@theoden:users a, oninit@gimli:users b, custdb@custsite:users>>> c
>>> Where a.uid = b.uid
>>> And a.uid = c.uid
>>>
>>> Works happenly
>>>
>>> Cheers
>>> Paul
>>>
>>> -----Original Message-----
>>> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Art
>>> Kagel
>>> Sent: Monday, May 27, 2013 4:07 PM
>>> To: ids@iiug.org
>>> Subject: Re: How tu use a table on another Instance [30350]
>>>
>>> The only caviat is that only enterprise edition supports distributed
>>> queries!
>>>
>>> The alternative, if you are using Growth/Workgroup Edition, Innovator
>>> Edition, or Express Edition, would be to use ER to replicate the table to
>>> the HDR pair.
>>>
>>> Art
>>> On May 27, 2013 4:03 PM, "Marcus Haarmann" <marcus.haarmann@midoco.de>
>>> wrote:
>>>
>>>> Hi,
>>>>
>>>> you should be able to query the table using the syntax
>>>> select field1, field2 ... from database@instance_z:table ...>>>> If the instance_z is in your sqlhosts of instance y and z trusts y
>>>> (hosts.equiv or .rhosts e.g).
>>>> Direct access can be tested with dbaccess (dbaccess
>>> database@instance_zshould
>>>> work directly
>>>> from y machine).
>>>>
>>>> Marcus
>>>>
>>>> ----- Ursprüngliche Mail -----
>>>>
>>>> Von: "SMITH JOHN" <daylight@webmails.com>
>>>> An: ids@iiug.org
>>>> Gesendet: Montag, 27. Mai 2013 21:22:31
>>>> Betreff: How tu use a table on another Instance [30348]
>>>>
>>>> Hi,
>>>>
>>>> I have my instance (11.50) "x" replicated with hdr "y", i made a third
>>> ids
>>>
>>>> server "z" that contains a table which i want to acces from the "y"
>>>> server, so
>>>> what are the steps to do so, please ?
>>>>
>>>> thanks in advance
>>>
>>>
****************************************************************************
>>> ***
>>>> Forum Note: Use "Reply" to post a response in the discussion forum.
>>>
>>>
****************************************************************************
>>> ***
>>>> Forum Note: Use "Reply" to post a response in the discussion forum.
>>>
>>> --089e0117749dac969404ddb9851a
>>>
>>>
>>>
****************************************************************************
>>> ***
>>> Forum Note: Use "Reply" to post a response in the discussion forum.
>>
*******************************************************************************
>>> Forum Note: Use "Reply" to post a response in the discussion forum.
>>
>> --001a11c33ffc5865b304ddba2281
>>
>>
>>
*******************************************************************************
>> Forum Note: Use "Reply" to post a response in the discussion forum.
No. The nee festure is now called Sharded Queries.
Art
On May 27, 2013 6:27 PM, "Paul Watson" <paul@oninit.com> wrote:
> Aren't we confusing distributed queries and distributed/grid queries - the
> later would need the ultimate/enterprise/whatever it is call this week
> version
>
> AFAIK Marketing didn't like grid queries and called them distributed
> queries -
> some thing that has always been there - nothing like presenting a clear
> image
> :-)
>
> Cheers
> Paul
>
> Paul Watson
> Oninit www.oninit.com
> +1 913 387 7529
>
> On May 27, 2013, at 16:57, Paul Watson <paul@oninit.com> wrote:
>
> > Wow that has been a part of informix since forever - a show stopper for
> many
> I should think
> >
> > Cheers
> > Paul
> >
> > Paul Watson
> > Oninit www.oninit.com
> > +1 913 387 7529
> >
> >
> > On May 27, 2013, at 16:50, "Art Kagel" <art.kagel@gmail.com> wrote:
> >
> >> According to the edition feature list tgat Carlton put together it's not
> >> supported/permitted.
> >>
> >> Art
> >> On May 27, 2013 5:25 PM, "Paul Watson" <paul@oninit.com> wrote:
> >>
> >>> Hmmm you sure are about that
> >>>
> >>> On my workgroup 11.70
> >>>
> >>> Select *
> >>>> From oninit@theoden:users a, oninit@gimli:users b, custdb@custsite> :users
> >>> c
> >>> Where a.uid = b.uid
> >>> And a.uid = c.uid
> >>>
> >>> Works happenly
> >>>
> >>> Cheers
> >>> Paul
> >>>
> >>> -----Original Message-----
> >>> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
> Art
> >>> Kagel
> >>> Sent: Monday, May 27, 2013 4:07 PM
> >>> To: ids@iiug.org
> >>> Subject: Re: How tu use a table on another Instance [30350]
> >>>
> >>> The only caviat is that only enterprise edition supports distributed
> >>> queries!
> >>>
> >>> The alternative, if you are using Growth/Workgroup Edition, Innovator
> >>> Edition, or Express Edition, would be to use ER to replicate the table
> to
> >>> the HDR pair.
> >>>
> >>> Art
> >>> On May 27, 2013 4:03 PM, "Marcus Haarmann" <marcus.haarmann@midoco.de>
> >>> wrote:
> >>>
> >>>> Hi,
> >>>>
> >>>> you should be able to query the table using the syntax
> >>>> select field1, field2 ... from database@instance_z:table ...> >>>> If the instance_z is in your sqlhosts of instance y and z trusts y
> >>>> (hosts.equiv or .rhosts e.g).
> >>>> Direct access can be tested with dbaccess (dbaccess
> >>> database@instance_zshould
> >>>> work directly
> >>>> from y machine).
> >>>>
> >>>> Marcus
> >>>>
> >>>> ----- Ursprüngliche Mail -----
> >>>>
> >>>> Von: "SMITH JOHN" <daylight@webmails.com>
> >>>> An: ids@iiug.org
> >>>> Gesendet: Montag, 27. Mai 2013 21:22:31
> >>>> Betreff: How tu use a table on another Instance [30348]
> >>>>
> >>>> Hi,
> >>>>
> >>>> I have my instance (11.50) "x" replicated with hdr "y", i made a third
> >>> ids
> >>>
> >>>> server "z" that contains a table which i want to acces from the "y"
> >>>> server, so
> >>>> what are the steps to do so, please ?
> >>>>
> >>>> thanks in advance
> >>>
> >>>
>
> ****************************************************************************
> >>> ***
> >>>> Forum Note: Use "Reply" to post a response in the discussion forum.
> >>>
> >>>
>
> ****************************************************************************
> >>> ***
> >>>> Forum Note: Use "Reply" to post a response in the discussion forum.
> >>>
> >>> --089e0117749dac969404ddb9851a
> >>>
> >>>
> >>>
>
> ****************************************************************************
> >>> ***
> >>> Forum Note: Use "Reply" to post a response in the discussion forum.
> >>
>
>
*******************************************************************************
> >>> Forum Note: Use "Reply" to post a response in the discussion forum.
> >>
> >> --001a11c33ffc5865b304ddba2281
> >>
> >>
> >>
>
>
*******************************************************************************
> >> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--089e0158ad545407cb04ddbad24a
As far as what you can or cannot do on Informix licence, you can take a
look at the following links
GROWTH EDITION 11.70:
http://www-03.ibm.com/software/sla/sladb.nsf/lilookup/461F2F1336373573852577B900
760678?opendocument&li_select=1947B9B1AC94F35E852577B900760663
<http://www-03.ibm.com/software/sla/sladb.nsf/lilookup/461F2F1336373573852577B90
0760678?opendocument&li_select=1947B9B1AC94F35E852577B900760663>
INNOVATOR EDITION 12.10:
http://www-03.ibm.com/software/sla/sladb.nsf/lilookup/0887266954F207D485257B3900
6E61E7?opendocument&li_select=ADB74C74E9DA58E285257B39006E61E4
<http://www-03.ibm.com/software/sla/sladb.nsf/lilookup/0887266954F207D485257B390
06E61E7?opendocument&li_select=ADB74C74E9DA58E285257B39006E61E4>
EXPRESS EDITION 12.10
http://www-03.ibm.com/software/sla/sladb.nsf/lilookup/B6B29948B09C326685257B3900
6E5C7E?opendocument&li_select=CD98439169F436CD85257B39006E5C78
<http://www-03.ibm.com/software/sla/sladb.nsf/lilookup/B6B29948B09C326685257B390
06E5C7E?opendocument&li_select=CD98439169F436CD85257B39006E5C78>
ENTERPRISE EDITION 12.10
http://www-03.ibm.com/software/sla/sladb.nsf/lilookup/398EE603D19D9DC585257B3900
6E4179?opendocument&li_select=2EBE7D020F3BABC185257B39006E4171
<http://www-03.ibm.com/software/sla/sladb.nsf/lilookup/398EE603D19D9DC585257B390
06E4179?opendocument&li_select=2EBE7D020F3BABC185257B39006E4171>
ADVANCED ENTERPRISE EDITION 12.10
http://www-03.ibm.com/software/sla/sladb.nsf/lilookup/4119FDE5E65F9B7B85257B3900
6E6A34?opendocument&li_select=6F37F7CB2DC7EEB685257B39006E6A2C
<http://www-03.ibm.com/software/sla/sladb.nsf/lilookup/4119FDE5E65F9B7B85257B390
06E6A34?opendocument&li_select=6F37F7CB2DC7EEB685257B39006E6A2C>
WORKGROUP EDITION 12.10
http://www-03.ibm.com/software/sla/sladb.nsf/lilookup/C0FBB06E64111A1E85257B3900
6E4FF8?opendocument&li_select=EF615619D42527C885257B39006E4FF5
<http://www-03.ibm.com/software/sla/sladb.nsf/lilookup/C0FBB06E64111A1E85257B390
06E4FF8?opendocument&li_select=EF615619D42527C885257B39006E4FF5>
ADVANCED WORKGROUP EDITION 12.10
http://www-03.ibm.com/software/sla/sladb.nsf/lilookup/C0A71828327B397885257B3900
6E6EF5?opendocument&li_select=4943C7E5B795078F85257B39006E6EF2
<http://www-03.ibm.com/software/sla/sladb.nsf/lilookup/C0A71828327B397885257B390
06E6EF5?opendocument&li_select=4943C7E5B795078F85257B39006E6EF2>
It gives you the list of prohibited components.
There are other links for the rest of the Informix products. These links
are the official "IBM License Information Documents" that you can go by.
It is true that distributed queries are prohibited on a GROWTH/WORKGROUP
Edition. Which is really too bad, but !!!!
Cordialement, Regards,
Khaled Bentebal
Directeur Général - ConsultiX
Président UGIF - User Group Informix France
IIUG - Board of Directors
Tél: 33 (0) 1 39 12 18 00
Fax: 33 (0) 1 39 12 18 18
Mobile: 33 (0) 6 07 78 41 97
Email: khaled.bentebal@consult-ix.fr
Site Web: www.consult-ix.fr
Le 27/05/13 23:06, Art Kagel a écrit :
> The only caviat is that only enterprise edition supports distributed
> queries!
>
> The alternative, if you are using Growth/Workgroup Edition, Innovator
> Edition, or Express Edition, would be to use ER to replicate the table to
> the HDR pair.
>
> Art
> On May 27, 2013 4:03 PM, "Marcus Haarmann"<marcus.haarmann@midoco.de>
> wrote:
>
>> Hi,
>>
>> you should be able to query the table using the syntax
>> select field1, field2 ... from database@instance_z:table ...>> If the instance_z is in your sqlhosts of instance y and z trusts y
>> (hosts.equiv or .rhosts e.g).
>> Direct access can be tested with dbaccess (dbaccess
> database@instance_zshould
>> work directly
>> from y machine).
>>
>> Marcus
>>
>> ----- Ursprüngliche Mail -----
>>
>> Von: "SMITH JOHN"<daylight@webmails.com>
>> An: ids@iiug.org
>> Gesendet: Montag, 27. Mai 2013 21:22:31
>> Betreff: How tu use a table on another Instance [30348]
>>
>> Hi,
>>
>> I have my instance (11.50) "x" replicated with hdr "y", i made a third ids
>> server "z" that contains a table which i want to acces from the "y"
>> server, so
>> what are the steps to do so, please ?
>>
>> thanks in advance
>>
>>
>>
>>
>
*******************************************************************************
>> Forum Note: Use "Reply" to post a response in the discussion forum.
>>
>>
>>
>>
>
*******************************************************************************
>> Forum Note: Use "Reply" to post a response in the discussion forum.
>>
>>
> --089e0117749dac969404ddb9851a
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
And there in the Workgroup Edition and the older Growth Edition prohibited
features lists is "Distributed Operations" and "Distributed queries
(I-Star)" respectively. As stated.
Art
Art S. Kagel
Advanced DataTools (www.advancedatatools.com)
Blog: http://informix-myview.blogspot.com/
Disclaimer: Please keep in mind that my own opinions are my own opinions
and do not reflect on my employer, Advanced DataTools, the IIUG, nor any
other organization with which I am associated either explicitly,
implicitly, or by inference. Neither do those opinions reflect those of
other individuals affiliated with any entity with which I am affiliated nor
those of the entities themselves.
On Tue, May 28, 2013 at 12:30 PM, Khaled Bentebal <
khaled.bentebal@consult-ix.fr> wrote:
> As far as what you can or cannot do on Informix licence, you can take a
> look at the following links
>
> GROWTH EDITION 11.70:
>
>
>
>
http://www-03.ibm.com/software/sla/sladb.nsf/lilookup/461F2F1336373573852577B900
760678?opendocument&li_select=1947B9B1AC94F35E852577B900760663
>
> <
>
http://www-03.ibm.com/software/sla/sladb.nsf/lilookup/461F2F1336373573852577B900
760678?opendocument&li_select=1947B9B1AC94F35E852577B900760663
> >
>
> INNOVATOR EDITION 12.10:
>
>
>
>
http://www-03.ibm.com/software/sla/sladb.nsf/lilookup/0887266954F207D485257B3900
6E61E7?opendocument&li_select=ADB74C74E9DA58E285257B39006E61E4
>
> <
>
http://www-03.ibm.com/software/sla/sladb.nsf/lilookup/0887266954F207D485257B3900
6E61E7?opendocument&li_select=ADB74C74E9DA58E285257B39006E61E4
> >
>
> EXPRESS EDITION 12.10
>
>
>
>
http://www-03.ibm.com/software/sla/sladb.nsf/lilookup/B6B29948B09C326685257B3900
6E5C7E?opendocument&li_select=CD98439169F436CD85257B39006E5C78
>
> <
>
http://www-03.ibm.com/software/sla/sladb.nsf/lilookup/B6B29948B09C326685257B3900
6E5C7E?opendocument&li_select=CD98439169F436CD85257B39006E5C78
> >
>
> ENTERPRISE EDITION 12.10
>
>
>
>
http://www-03.ibm.com/software/sla/sladb.nsf/lilookup/398EE603D19D9DC585257B3900
6E4179?opendocument&li_select=2EBE7D020F3BABC185257B39006E4171
>
> <
>
http://www-03.ibm.com/software/sla/sladb.nsf/lilookup/398EE603D19D9DC585257B3900
6E4179?opendocument&li_select=2EBE7D020F3BABC185257B39006E4171
> >
>
> ADVANCED ENTERPRISE EDITION 12.10
>
>
>
>
http://www-03.ibm.com/software/sla/sladb.nsf/lilookup/4119FDE5E65F9B7B85257B3900
6E6A34?opendocument&li_select=6F37F7CB2DC7EEB685257B39006E6A2C
>
> <
>
http://www-03.ibm.com/software/sla/sladb.nsf/lilookup/4119FDE5E65F9B7B85257B3900
6E6A34?opendocument&li_select=6F37F7CB2DC7EEB685257B39006E6A2C
> >
>
> WORKGROUP EDITION 12.10
>
>
>
>
http://www-03.ibm.com/software/sla/sladb.nsf/lilookup/C0FBB06E64111A1E85257B3900
6E4FF8?opendocument&li_select=EF615619D42527C885257B39006E4FF5
>
> <
>
http://www-03.ibm.com/software/sla/sladb.nsf/lilookup/C0FBB06E64111A1E85257B3900
6E4FF8?opendocument&li_select=EF615619D42527C885257B39006E4FF5
> >
>
> ADVANCED WORKGROUP EDITION 12.10
>
>
>
>
http://www-03.ibm.com/software/sla/sladb.nsf/lilookup/C0A71828327B397885257B3900
6E6EF5?opendocument&li_select=4943C7E5B795078F85257B39006E6EF2
>
> <
>
http://www-03.ibm.com/software/sla/sladb.nsf/lilookup/C0A71828327B397885257B3900
6E6EF5?opendocument&li_select=4943C7E5B795078F85257B39006E6EF2
> >
>
> It gives you the list of prohibited components.
>
> There are other links for the rest of the Informix products. These links
> are the official "IBM License Information Documents" that you can go by.
>
> It is true that distributed queries are prohibited on a GROWTH/WORKGROUP
> Edition. Which is really too bad, but !!!!
>
> Cordialement, Regards,
>
> Khaled Bentebal
> Directeur Général - ConsultiX
> Président UGIF - User Group Informix France
> IIUG - Board of Directors
> Tél: 33 (0) 1 39 12 18 00
> Fax: 33 (0) 1 39 12 18 18
> Mobile: 33 (0) 6 07 78 41 97
> Email: khaled.bentebal@consult-ix.fr
> Site Web: www.consult-ix.fr
>
> Le 27/05/13 23:06, Art Kagel a écrit :
> > The only caviat is that only enterprise edition supports distributed
> > queries!
> >
> > The alternative, if you are using Growth/Workgroup Edition, Innovator
> > Edition, or Express Edition, would be to use ER to replicate the table to
> > the HDR pair.
> >
> > Art
> > On May 27, 2013 4:03 PM, "Marcus Haarmann"<marcus.haarmann@midoco.de>
> > wrote:
> >
> >> Hi,
> >>
> >> you should be able to query the table using the syntax
> >> select field1, field2 ... from database@instance_z:table ...> >> If the instance_z is in your sqlhosts of instance y and z trusts y
> >> (hosts.equiv or .rhosts e.g).
> >> Direct access can be tested with dbaccess (dbaccess
> > database@instance_zshould
> >> work directly
> >> from y machine).
> >>
> >> Marcus
> >>
> >> ----- Ursprüngliche Mail -----
> >>
> >> Von: "SMITH JOHN"<daylight@webmails.com>
> >> An: ids@iiug.org
> >> Gesendet: Montag, 27. Mai 2013 21:22:31
> >> Betreff: How tu use a table on another Instance [30348]
> >>
> >> Hi,
> >>
> >> I have my instance (11.50) "x" replicated with hdr "y", i made a third
> ids
> >> server "z" that contains a table which i want to acces from the "y"
> >> server, so
> >> what are the steps to do so, please ?
> >>
> >> thanks in advance
> >>
> >>
> >>
> >>
> >
>
>
*******************************************************************************
> >> Forum Note: Use "Reply" to post a response in the discussion forum.
> >>
> >>
> >>
> >>
> >
>
>
*******************************************************************************
> >> Forum Note: Use "Reply" to post a response in the discussion forum.
> >>
> >>
> > --089e0117749dac969404ddb9851a
> >
> >
> >
>
>
*******************************************************************************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--089e0160b8843a02b104ddc9f681
Suspect they are many, if not all none enterprise/ultimate/whatever
installations, are in breach of the license then.
The simple
Select * from prod where value not in (select * from uat) ;
Insert into test select broken_date from prod;
etc
are no longer allowed.
Cheers
Paul
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Art
Kagel
Sent: Tuesday, May 28, 2013 11:44 AM
To: ids@iiug.org
Subject: Re: How tu use a table on another Instance [30366]
And there in the Workgroup Edition and the older Growth Edition prohibited
features lists is "Distributed Operations" and "Distributed queries
(I-Star)" respectively. As stated.
Art
Art S. Kagel
Advanced DataTools (www.advancedatatools.com)
Blog: http://informix-myview.blogspot.com/
Disclaimer: Please keep in mind that my own opinions are my own opinions
and do not reflect on my employer, Advanced DataTools, the IIUG, nor any
other organization with which I am associated either explicitly,
implicitly, or by inference. Neither do those opinions reflect those of
other individuals affiliated with any entity with which I am affiliated nor
those of the entities themselves.
On Tue, May 28, 2013 at 12:30 PM, Khaled Bentebal <
khaled.bentebal@consult-ix.fr> wrote:
> As far as what you can or cannot do on Informix licence, you can take a
> look at the following links
>
> GROWTH EDITION 11.70:
>
>
>
>
http://www-03.ibm.com/software/sla/sladb.nsf/lilookup/461F2F1336373573852577
B900760678?opendocument&li_select=1947B9B1AC94F35E852577B900760663
>
> <
>
http://www-03.ibm.com/software/sla/sladb.nsf/lilookup/461F2F1336373573852577
B900760678?opendocument&li_select=1947B9B1AC94F35E852577B900760663
> >
>
> INNOVATOR EDITION 12.10:
>
>
>
>
http://www-03.ibm.com/software/sla/sladb.nsf/lilookup/0887266954F207D485257B
39006E61E7?opendocument&li_select=ADB74C74E9DA58E285257B39006E61E4
>
> <
>
http://www-03.ibm.com/software/sla/sladb.nsf/lilookup/0887266954F207D485257B
39006E61E7?opendocument&li_select=ADB74C74E9DA58E285257B39006E61E4
> >
>
> EXPRESS EDITION 12.10
>
>
>
>
http://www-03.ibm.com/software/sla/sladb.nsf/lilookup/B6B29948B09C326685257B
39006E5C7E?opendocument&li_select=CD98439169F436CD85257B39006E5C78
>
> <
>
http://www-03.ibm.com/software/sla/sladb.nsf/lilookup/B6B29948B09C326685257B
39006E5C7E?opendocument&li_select=CD98439169F436CD85257B39006E5C78
> >
>
> ENTERPRISE EDITION 12.10
>
>
>
>
http://www-03.ibm.com/software/sla/sladb.nsf/lilookup/398EE603D19D9DC585257B
39006E4179?opendocument&li_select=2EBE7D020F3BABC185257B39006E4171
>
> <
>
http://www-03.ibm.com/software/sla/sladb.nsf/lilookup/398EE603D19D9DC585257B
39006E4179?opendocument&li_select=2EBE7D020F3BABC185257B39006E4171
> >
>
> ADVANCED ENTERPRISE EDITION 12.10
>
>
>
>
http://www-03.ibm.com/software/sla/sladb.nsf/lilookup/4119FDE5E65F9B7B85257B
39006E6A34?opendocument&li_select=6F37F7CB2DC7EEB685257B39006E6A2C
>
> <
>
http://www-03.ibm.com/software/sla/sladb.nsf/lilookup/4119FDE5E65F9B7B85257B
39006E6A34?opendocument&li_select=6F37F7CB2DC7EEB685257B39006E6A2C
> >
>
> WORKGROUP EDITION 12.10
>
>
>
>
http://www-03.ibm.com/software/sla/sladb.nsf/lilookup/C0FBB06E64111A1E85257B
39006E4FF8?opendocument&li_select=EF615619D42527C885257B39006E4FF5
>
> <
>
http://www-03.ibm.com/software/sla/sladb.nsf/lilookup/C0FBB06E64111A1E85257B
39006E4FF8?opendocument&li_select=EF615619D42527C885257B39006E4FF5
> >
>
> ADVANCED WORKGROUP EDITION 12.10
>
>
>
>
http://www-03.ibm.com/software/sla/sladb.nsf/lilookup/C0A71828327B397885257B
39006E6EF5?opendocument&li_select=4943C7E5B795078F85257B39006E6EF2
>
> <
>
http://www-03.ibm.com/software/sla/sladb.nsf/lilookup/C0A71828327B397885257B
39006E6EF5?opendocument&li_select=4943C7E5B795078F85257B39006E6EF2
> >
>
> It gives you the list of prohibited components.
>
> There are other links for the rest of the Informix products. These links
> are the official "IBM License Information Documents" that you can go by.
>
> It is true that distributed queries are prohibited on a GROWTH/WORKGROUP
> Edition. Which is really too bad, but !!!!
>
> Cordialement, Regards,
>
> Khaled Bentebal
> Directeur Général - ConsultiX
> Président UGIF - User Group Informix France
> IIUG - Board of Directors
> Tél: 33 (0) 1 39 12 18 00
> Fax: 33 (0) 1 39 12 18 18
> Mobile: 33 (0) 6 07 78 41 97
> Email: khaled.bentebal@consult-ix.fr
> Site Web: www.consult-ix.fr
>
> Le 27/05/13 23:06, Art Kagel a écrit :
> > The only caviat is that only enterprise edition supports distributed
> > queries!
> >
> > The alternative, if you are using Growth/Workgroup Edition, Innovator
> > Edition, or Express Edition, would be to use ER to replicate the table
to
> > the HDR pair.
> >
> > Art
> > On May 27, 2013 4:03 PM, "Marcus Haarmann"<marcus.haarmann@midoco.de>
> > wrote:
> >
> >> Hi,
> >>
> >> you should be able to query the table using the syntax
> >> select field1, field2 ... from database@instance_z:table ...> >> If the instance_z is in your sqlhosts of instance y and z trusts y
> >> (hosts.equiv or .rhosts e.g).
> >> Direct access can be tested with dbaccess (dbaccess
> > database@instance_zshould
> >> work directly
> >> from y machine).
> >>
> >> Marcus
> >>
> >> ----- Ursprüngliche Mail -----
> >>
> >> Von: "SMITH JOHN"<daylight@webmails.com>
> >> An: ids@iiug.org
> >> Gesendet: Montag, 27. Mai 2013 21:22:31
> >> Betreff: How tu use a table on another Instance [30348]
> >>
> >> Hi,
> >>
> >> I have my instance (11.50) "x" replicated with hdr "y", i made a third
> ids
> >> server "z" that contains a table which i want to acces from the "y"
> >> server, so
> >> what are the steps to do so, please ?
> >>
> >> thanks in advance
> >>
> >>
> >>
> >>
> >
>
>
****************************************************************************
***
> >> Forum Note: Use "Reply" to post a response in the discussion forum.
> >>
> >>
> >>
> >>
> >
>
>
****************************************************************************
***
> >> Forum Note: Use "Reply" to post a response in the discussion forum.
> >>
> >>
> > --089e0117749dac969404ddb9851a
> >
> >
> >
>
>
****************************************************************************
***
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
>
>
>
>
****************************************************************************
***
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--089e0160b8843a02b104ddc9f681
******************************
Those aren't distributed queries, Paul. They only reference the local
server.
Art
Art S. Kagel
Advanced DataTools (www.advancedatatools.com)
Blog: http://informix-myview.blogspot.com/
Disclaimer: Please keep in mind that my own opinions are my own opinions
and do not reflect on my employer, Advanced DataTools, the IIUG, nor any
other organization with which I am associated either explicitly,
implicitly, or by inference. Neither do those opinions reflect those of
other individuals affiliated with any entity with which I am affiliated nor
those of the entities themselves.
On Tue, May 28, 2013 at 1:17 PM, Paul Watson <paul@oninit.com> wrote:
> Suspect they are many, if not all none enterprise/ultimate/whatever
> installations, are in breach of the license then.
>
> The simple
>
> Select * from prod where value not in (select * from uat) ;
> Insert into test select broken_date from prod;>
> etc
>
> are no longer allowed.
>
> Cheers
> Paul
>
> -----Original Message-----
> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Art
> Kagel
> Sent: Tuesday, May 28, 2013 11:44 AM
> To: ids@iiug.org
> Subject: Re: How tu use a table on another Instance [30366]
>
> And there in the Workgroup Edition and the older Growth Edition prohibited
> features lists is "Distributed Operations" and "Distributed queries
> (I-Star)" respectively. As stated.
>
> Art
>
> Art S. Kagel
> Advanced DataTools (www.advancedatatools.com)
> Blog: http://informix-myview.blogspot.com/
>
> Disclaimer: Please keep in mind that my own opinions are my own opinions
> and do not reflect on my employer, Advanced DataTools, the IIUG, nor any
> other organization with which I am associated either explicitly,
> implicitly, or by inference. Neither do those opinions reflect those of
> other individuals affiliated with any entity with which I am affiliated nor
> those of the entities themselves.
>
> On Tue, May 28, 2013 at 12:30 PM, Khaled Bentebal <
> khaled.bentebal@consult-ix.fr> wrote:
>
> > As far as what you can or cannot do on Informix licence, you can take a
> > look at the following links
> >
> > GROWTH EDITION 11.70:
> >
> >
> >
> >
>
> http://www-03.ibm.com/software/sla/sladb.nsf/lilookup/461F2F1336373573852577
> B900760678?opendocument&li_select=1947B9B1AC94F35E852577B900760663
> >
> > <
> >
>
> http://www-03.ibm.com/software/sla/sladb.nsf/lilookup/461F2F1336373573852577
> B900760678?opendocument&li_select=1947B9B1AC94F35E852577B900760663
> > >
> >
> > INNOVATOR EDITION 12.10:
> >
> >
> >
> >
>
> http://www-03.ibm.com/software/sla/sladb.nsf/lilookup/0887266954F207D485257B
> 39006E61E7?opendocument&li_select=ADB74C74E9DA58E285257B39006E61E4
> >
> > <
> >
>
> http://www-03.ibm.com/software/sla/sladb.nsf/lilookup/0887266954F207D485257B
> 39006E61E7?opendocument&li_select=ADB74C74E9DA58E285257B39006E61E4
> > >
> >
> > EXPRESS EDITION 12.10
> >
> >
> >
> >
>
> http://www-03.ibm.com/software/sla/sladb.nsf/lilookup/B6B29948B09C326685257B
> 39006E5C7E?opendocument&li_select=CD98439169F436CD85257B39006E5C78
> >
> > <
> >
>
> http://www-03.ibm.com/software/sla/sladb.nsf/lilookup/B6B29948B09C326685257B
> 39006E5C7E?opendocument&li_select=CD98439169F436CD85257B39006E5C78
> > >
> >
> > ENTERPRISE EDITION 12.10
> >
> >
> >
> >
>
> http://www-03.ibm.com/software/sla/sladb.nsf/lilookup/398EE603D19D9DC585257B
> 39006E4179?opendocument&li_select=2EBE7D020F3BABC185257B39006E4171
> >
> > <
> >
>
> http://www-03.ibm.com/software/sla/sladb.nsf/lilookup/398EE603D19D9DC585257B
> 39006E4179?opendocument&li_select=2EBE7D020F3BABC185257B39006E4171
> > >
> >
> > ADVANCED ENTERPRISE EDITION 12.10
> >
> >
> >
> >
>
> http://www-03.ibm.com/software/sla/sladb.nsf/lilookup/4119FDE5E65F9B7B85257B
> 39006E6A34?opendocument&li_select=6F37F7CB2DC7EEB685257B39006E6A2C
> >
> > <
> >
>
> http://www-03.ibm.com/software/sla/sladb.nsf/lilookup/4119FDE5E65F9B7B85257B
> 39006E6A34?opendocument&li_select=6F37F7CB2DC7EEB685257B39006E6A2C
> > >
> >
> > WORKGROUP EDITION 12.10
> >
> >
> >
> >
>
> http://www-03.ibm.com/software/sla/sladb.nsf/lilookup/C0FBB06E64111A1E85257B
> 39006E4FF8?opendocument&li_select=EF615619D42527C885257B39006E4FF5
> >
> > <
> >
>
> http://www-03.ibm.com/software/sla/sladb.nsf/lilookup/C0FBB06E64111A1E85257B
> 39006E4FF8?opendocument&li_select=EF615619D42527C885257B39006E4FF5
> > >
> >
> > ADVANCED WORKGROUP EDITION 12.10
> >
> >
> >
> >
>
> http://www-03.ibm.com/software/sla/sladb.nsf/lilookup/C0A71828327B397885257B
> 39006E6EF5?opendocument&li_select=4943C7E5B795078F85257B39006E6EF2
> >
> > <
> >
>
> http://www-03.ibm.com/software/sla/sladb.nsf/lilookup/C0A71828327B397885257B
> 39006E6EF5?opendocument&li_select=4943C7E5B795078F85257B39006E6EF2
> > >
> >
> > It gives you the list of prohibited components.
> >
> > There are other links for the rest of the Informix products. These links
> > are the official "IBM License Information Documents" that you can go by.
> >
> > It is true that distributed queries are prohibited on a GROWTH/WORKGROUP
> > Edition. Which is really too bad, but !!!!
> >
> > Cordialement, Regards,
> >
> > Khaled Bentebal
> > Directeur Général - ConsultiX
> > Président UGIF - User Group Informix France
> > IIUG - Board of Directors
> > Tél: 33 (0) 1 39 12 18 00
> > Fax: 33 (0) 1 39 12 18 18
> > Mobile: 33 (0) 6 07 78 41 97
> > Email: khaled.bentebal@consult-ix.fr
> > Site Web: www.consult-ix.fr
> >
> > Le 27/05/13 23:06, Art Kagel a écrit :
> > > The only caviat is that only enterprise edition supports distributed
> > > queries!
> > >
> > > The alternative, if you are using Growth/Workgroup Edition, Innovator
> > > Edition, or Express Edition, would be to use ER to replicate the table
> to
> > > the HDR pair.
> > >
> > > Art
> > > On May 27, 2013 4:03 PM, "Marcus Haarmann"<marcus.haarmann@midoco.de>
> > > wrote:
> > >
> > >> Hi,
> > >>
> > >> you should be able to query the table using the syntax
> > >> select field1, field2 ... from database@instance_z:table ...> > >> If the instance_z is in your sqlhosts of instance y and z trusts y
> > >> (hosts.equiv or .rhosts e.g).
> > >> Direct access can be tested with dbaccess (dbaccess
> > > database@instance_zshould
> > >> work directly
> > >> from y machine).
> > >>
> > >> Marcus
> > >>
> > >> ----- Ursprüngliche Mail -----
> > >>
> > >> Von: "SMITH JOHN"<daylight@webmails.com>
> > >> An: ids@iiug.org
> > >> Gesendet: Montag, 27. Mai 2013 21:22:31
> > >> Betreff: How tu use a table on another Instance [30348]
> > >>
> > >> Hi,
> > >>
> > >> I have my instance (11.50) "x" replicated with hdr "y", i made a third
> > ids
> > >> server "z" that contains a table whic
OK I was being lazy
Select * from prodinstance@proddb:prodtable
Where value not in (select * from uatinstance@proddb:prodtable)
Cheers
Paul
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Art
Kagel
Sent: Tuesday, May 28, 2013 12:25 PM
To: ids@iiug.org
Subject: Re: How tu use a table on another Instance [30368]
Those aren't distributed queries, Paul. They only reference the local
server.
Art
Art S. Kagel
Advanced DataTools (www.advancedatatools.com)
Blog: http://informix-myview.blogspot.com/
Disclaimer: Please keep in mind that my own opinions are my own opinions
and do not reflect on my employer, Advanced DataTools, the IIUG, nor any
other organization with which I am associated either explicitly,
implicitly, or by inference. Neither do those opinions reflect those of
other individuals affiliated with any entity with which I am affiliated nor
those of the entities themselves.
On Tue, May 28, 2013 at 1:17 PM, Paul Watson <paul@oninit.com> wrote:
> Suspect they are many, if not all none enterprise/ultimate/whatever
> installations, are in breach of the license then.
>
> The simple
>
> Select * from prod where value not in (select * from uat) ;
> Insert into test select broken_date from prod;>
> etc
>
> are no longer allowed.
>
> Cheers
> Paul
>
> -----Original Message-----
> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Art
> Kagel
> Sent: Tuesday, May 28, 2013 11:44 AM
> To: ids@iiug.org
> Subject: Re: How tu use a table on another Instance [30366]
>
> And there in the Workgroup Edition and the older Growth Edition prohibited
> features lists is "Distributed Operations" and "Distributed queries
> (I-Star)" respectively. As stated.
>
> Art
>
> Art S. Kagel
> Advanced DataTools (www.advancedatatools.com)
> Blog: http://informix-myview.blogspot.com/
>
> Disclaimer: Please keep in mind that my own opinions are my own opinions
> and do not reflect on my employer, Advanced DataTools, the IIUG, nor any
> other organization with which I am associated either explicitly,
> implicitly, or by inference. Neither do those opinions reflect those of
> other individuals affiliated with any entity with which I am affiliated
nor
> those of the entities themselves.
>
> On Tue, May 28, 2013 at 12:30 PM, Khaled Bentebal <
> khaled.bentebal@consult-ix.fr> wrote:
>
> > As far as what you can or cannot do on Informix licence, you can take a
> > look at the following links
> >
> > GROWTH EDITION 11.70:
> >
> >
> >
> >
>
>
http://www-03.ibm.com/software/sla/sladb.nsf/lilookup/461F2F1336373573852577
> B900760678?opendocument&li_select=1947B9B1AC94F35E852577B900760663
> >
> > <
> >
>
>
http://www-03.ibm.com/software/sla/sladb.nsf/lilookup/461F2F1336373573852577
> B900760678?opendocument&li_select=1947B9B1AC94F35E852577B900760663
> > >
> >
> > INNOVATOR EDITION 12.10:
> >
> >
> >
> >
>
>
http://www-03.ibm.com/software/sla/sladb.nsf/lilookup/0887266954F207D485257B
> 39006E61E7?opendocument&li_select=ADB74C74E9DA58E285257B39006E61E4
> >
> > <
> >
>
>
http://www-03.ibm.com/software/sla/sladb.nsf/lilookup/0887266954F207D485257B
> 39006E61E7?opendocument&li_select=ADB74C74E9DA58E285257B39006E61E4
> > >
> >
> > EXPRESS EDITION 12.10
> >
> >
> >
> >
>
>
http://www-03.ibm.com/software/sla/sladb.nsf/lilookup/B6B29948B09C326685257B
> 39006E5C7E?opendocument&li_select=CD98439169F436CD85257B39006E5C78
> >
> > <
> >
>
>
http://www-03.ibm.com/software/sla/sladb.nsf/lilookup/B6B29948B09C326685257B
> 39006E5C7E?opendocument&li_select=CD98439169F436CD85257B39006E5C78
> > >
> >
> > ENTERPRISE EDITION 12.10
> >
> >
> >
> >
>
>
http://www-03.ibm.com/software/sla/sladb.nsf/lilookup/398EE603D19D9DC585257B
> 39006E4179?opendocument&li_select=2EBE7D020F3BABC185257B39006E4171
> >
> > <
> >
>
>
http://www-03.ibm.com/software/sla/sladb.nsf/lilookup/398EE603D19D9DC585257B
> 39006E4179?opendocument&li_select=2EBE7D020F3BABC185257B39006E4171
> > >
> >
> > ADVANCED ENTERPRISE EDITION 12.10
> >
> >
> >
> >
>
>
http://www-03.ibm.com/software/sla/sladb.nsf/lilookup/4119FDE5E65F9B7B85257B
> 39006E6A34?opendocument&li_select=6F37F7CB2DC7EEB685257B39006E6A2C
> >
> > <
> >
>
>
http://www-03.ibm.com/software/sla/sladb.nsf/lilookup/4119FDE5E65F9B7B85257B
> 39006E6A34?opendocument&li_select=6F37F7CB2DC7EEB685257B39006E6A2C
> > >
> >
> > WORKGROUP EDITION 12.10
> >
> >
> >
> >
>
>
http://www-03.ibm.com/software/sla/sladb.nsf/lilookup/C0FBB06E64111A1E85257B
> 39006E4FF8?opendocument&li_select=EF615619D42527C885257B39006E4FF5
> >
> > <
> >
>
>
http://www-03.ibm.com/software/sla/sladb.nsf/lilookup/C0FBB06E64111A1E85257B
> 39006E4FF8?opendocument&li_select=EF615619D42527C885257B39006E4FF5
> > >
> >
> > ADVANCED WORKGROUP EDITION 12.10
> >
> >
> >
> >
>
>
http://www-03.ibm.com/software/sla/sladb.nsf/lilookup/C0A71828327B397885257B
> 39006E6EF5?opendocument&li_select=4943C7E5B795078F85257B39006E6EF2
> >
> > <
> >
>
>
http://www-03.ibm.com/software/sla/sladb.nsf/lilookup/C0A71828327B397885257B
> 39006E6EF5?opendocument&li_select=4943C7E5B795078F85257B39006E6EF2
> > >
> >
> > It gives you the list of prohibited components.
> >
> > There are other links for the rest of the Informix products. These links
> > are the official "IBM License Information Documents" that you can go by.
> >
> > It is true that distributed queries are prohibited on a GROWTH/WORKGROUP
> > Edition. Which is really too bad, but !!!!
> >
> > Cordialement, Regards,
> >
> > Khaled Bentebal
> > Directeur Général - ConsultiX
> > Président UGIF - User Group Informix France
> > IIUG - Board of Directors
> > Tél: 33 (0) 1 39 12 18 00
> > Fax: 33 (0) 1 39 12 18 18
> > Mobile: 33 (0) 6 07 78 41 97
> > Email: khaled.bentebal@consult-ix.fr
> > Site Web: www.consult-ix.fr
> >
> > Le 27/05/13 23:06, Art Kagel a écrit :
> > > The only caviat is that only enterprise edition supports distributed
> > > queries!
> > >
> > > The alternative, if you are using Growth/Workgroup Edition, Innovator
> > > Edition, or Express Edition, would be to use ER to replicate the table
> to
> > > the HDR pair.
> > >
> > > Art
> > > On May 27, 2013 4:03 PM, "Marcus Haarmann"<marcus.haarmann@midoco.de>
> > > wrote:
> > >
> > >> Hi,
> > >>
> > >> you should be able to query the table using the syntax
> > >> select field1, field2 ... from database@instance_z:table ...> > >> If the instance_z is in your sqlhosts of instance y and z trusts y
> > >> (hosts.equiv or .rhosts e.g).
> > >> Direct access can be tested with d
Can I clarify what excluding the following from 12.10 Workgroup Edition means
"Storage Optimization Feature (Compression)"?
Excluding compression I can understand but asking IBMers implies this excludes
running online reorgs as well.
Even the express edition of MS SQL Server 2012 which only allows 1GB of memory
does not mention excluding online reorgs....response IBM?
http://msdn.microsoft.com/en-us/library/cc645993.aspx
<http://msdn.microsoft.com/en-us/library/cc645993.aspx>;
David.
On 28 May 2013 at 18:32 Paul Watson <paul@oninit.com> wrote:
> OK I was being lazy
>
> Select * from prodinstance@proddb:prodtable>
> Where value not in (select * from uatinstance@proddb:prodtable)
>
> Cheers
> Paul
>
> -----Original Message-----
> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Art
> Kagel
> Sent: Tuesday, May 28, 2013 12:25 PM
> To: ids@iiug.org
> Subject: Re: How tu use a table on another Instance [30368]
>
> Those aren't distributed queries, Paul. They only reference the local
> server.
>
> Art
>
> Art S. Kagel
> Advanced DataTools (www.advancedatatools.com)
> Blog: http://informix-myview.blogspot.com/
>
> Disclaimer: Please keep in mind that my own opinions are my own opinions
> and do not reflect on my employer, Advanced DataTools, the IIUG, nor any
> other organization with which I am associated either explicitly,
> implicitly, or by inference. Neither do those opinions reflect those of
> other individuals affiliated with any entity with which I am affiliated nor
> those of the entities themselves.
>
> On Tue, May 28, 2013 at 1:17 PM, Paul Watson <paul@oninit.com> wrote:
>
> > Suspect they are many, if not all none enterprise/ultimate/whatever
> > installations, are in breach of the license then.
> >
> > The simple
> >
> > Select * from prod where value not in (select * from uat) ;
> > Insert into test select broken_date from prod;> >
> > etc
> >
> > are no longer allowed.
> >
> > Cheers
> > Paul
> >
> > -----Original Message-----
> > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Art
> > Kagel
> > Sent: Tuesday, May 28, 2013 11:44 AM
> > To: ids@iiug.org
> > Subject: Re: How tu use a table on another Instance [30366]
> >
> > And there in the Workgroup Edition and the older Growth Edition prohibited
>
> > features lists is "Distributed Operations" and "Distributed queries
> > (I-Star)" respectively. As stated.
> >
> > Art
> >
> > Art S. Kagel
> > Advanced DataTools (www.advancedatatools.com)
> > Blog: http://informix-myview.blogspot.com/
> >
> > Disclaimer: Please keep in mind that my own opinions are my own opinions
> > and do not reflect on my employer, Advanced DataTools, the IIUG, nor any
> > other organization with which I am associated either explicitly,
> > implicitly, or by inference. Neither do those opinions reflect those of
> > other individuals affiliated with any entity with which I am affiliated
> nor
> > those of the entities themselves.
> >
> > On Tue, May 28, 2013 at 12:30 PM, Khaled Bentebal <
> > khaled.bentebal@consult-ix.fr> wrote:
> >
> > > As far as what you can or cannot do on Informix licence, you can take a
> > > look at the following links
> > >
> > > GROWTH EDITION 11.70:
> > >
> > >
> > >
> > >
> >
> >
> http://www-03.ibm.com/software/sla/sladb.nsf/lilookup/461F2F1336373573852577
>
> > B900760678?opendocument&li_select=1947B9B1AC94F35E852577B900760663
> > >
> > > <
> > >
> >
> >
> http://www-03.ibm.com/software/sla/sladb.nsf/lilookup/461F2F1336373573852577
>
> > B900760678?opendocument&li_select=1947B9B1AC94F35E852577B900760663
> > > >
> > >
> > > INNOVATOR EDITION 12.10:
> > >
> > >
> > >
> > >
> >
> >
> http://www-03.ibm.com/software/sla/sladb.nsf/lilookup/0887266954F207D485257B
>
> > 39006E61E7?opendocument&li_select=ADB74C74E9DA58E285257B39006E61E4
> > >
> > > <
> > >
> >
> >
> http://www-03.ibm.com/software/sla/sladb.nsf/lilookup/0887266954F207D485257B
>
> > 39006E61E7?opendocument&li_select=ADB74C74E9DA58E285257B39006E61E4
> > > >
> > >
> > > EXPRESS EDITION 12.10
> > >
> > >
> > >
> > >
> >
> >
> http://www-03.ibm.com/software/sla/sladb.nsf/lilookup/B6B29948B09C326685257B
>
> > 39006E5C7E?opendocument&li_select=CD98439169F436CD85257B39006E5C78
> > >
> > > <
> > >
> >
> >
> http://www-03.ibm.com/software/sla/sladb.nsf/lilookup/B6B29948B09C326685257B
>
> > 39006E5C7E?opendocument&li_select=CD98439169F436CD85257B39006E5C78
> > > >
> > >
> > > ENTERPRISE EDITION 12.10
> > >
> > >
> > >
> > >
> >
> >
> http://www-03.ibm.com/software/sla/sladb.nsf/lilookup/398EE603D19D9DC585257B
>
> > 39006E4179?opendocument&li_select=2EBE7D020F3BABC185257B39006E4171
> > >
> > > <
> > >
> >
> >
> http://www-03.ibm.com/software/sla/sladb.nsf/lilookup/398EE603D19D9DC585257B
>
> > 39006E4179?opendocument&li_select=2EBE7D020F3BABC185257B39006E4171
> > > >
> > >
> > > ADVANCED ENTERPRISE EDITION 12.10
> > >
> > >
> > >
> > >
> >
> >
> http://www-03.ibm.com/software/sla/sladb.nsf/lilookup/4119FDE5E65F9B7B85257B
>
> > 39006E6A34?opendocument&li_select=6F37F7CB2DC7EEB685257B39006E6A2C
> > >
> > > <
> > >
> >
> >
> http://www-03.ibm.com/software/sla/sladb.nsf/lilookup/4119FDE5E65F9B7B85257B
>
> > 39006E6A34?opendocument&li_select=6F37F7CB2DC7EEB685257B39006E6A2C
> > > >
> > >
> > > WORKGROUP EDITION 12.10
> > >
> > >
> > >
> > >
> >
> >
> http://www-03.ibm.com/software/sla/sladb.nsf/lilookup/C0FBB06E64111A1E85257B
>
> > 39006E4FF8?opendocument&li_select=EF615619D42527C885257B39006E4FF5
> > >
> > > <
> > >
> >
> >
> http://www-03.ibm.com/software/sla/sladb.nsf/lilookup/C0FBB06E64111A1E85257B
>
> > 39006E4FF8?opendocument&li_select=EF615619D42527C885257B39006E4FF5
> > > >
> > >
> > > ADVANCED WORKGROUP EDITION 12.10
> > >
> > >
> > >
> > >
> >
> >
> http://www-03.ibm.com/software/sla/sladb.nsf/lilookup/C0A71828327B397885257B
>
> > 39006E6EF5?opendocument&li_select=4943C7E5B795078F85257B39006E6EF2
> > >
> > > <
> > >
> >
> >
> http://www-03.ibm.com/software/sla/sladb.nsf/lilookup/C0A71828327B397885257B
>
> > 39006E6EF5?opendocument&li_select=4943C7E5B795078F85257B39006E6EF2
> > > >
> > >
> > > It gives you the list of prohibited components.
> > >
> > > There are other links for the rest of the Informix products. These links
>
> > > are the official "IBM License Information Documents" that you can go by.
>
> > >
> > > It is true that distributed queries are prohibited on a GROWTH/WORKGROUP
>
> > > Edition. Which is really too bad, but !!!!
> > >
> > > Cordialement, Regards,
> > >
> > > Khaled Bentebal
> > > Directeur Général - ConsultiX
> > > Président UGIF - User Group Informix F
As far as I know, David, the Storage Optimization restriction ONLY affects
compression. PACK, SHRINK, and DEFRAGMENT are all available and legal to
use in all Editions.
Art
Art S. Kagel
Advanced DataTools (www.advancedatatools.com)
Blog: http://informix-myview.blogspot.com/
Disclaimer: Please keep in mind that my own opinions are my own opinions
and do not reflect on my employer, Advanced DataTools, the IIUG, nor any
other organization with which I am associated either explicitly,
implicitly, or by inference. Neither do those opinions reflect those of
other individuals affiliated with any entity with which I am affiliated nor
those of the entities themselves.
On Tue, May 28, 2013 at 2:47 PM, david@smooth1.co.uk
<david@smooth1.co.uk>wrote:
> Can I clarify what excluding the following from 12.10 Workgroup Edition
> means
> "Storage Optimization Feature (Compression)"?
>
> Excluding compression I can understand but asking IBMers implies this
> excludes
> running online reorgs as well.
>
> Even the express edition of MS SQL Server 2012 which only allows 1GB of
> memory
> does not mention excluding online reorgs....response IBM?
>
> http://msdn.microsoft.com/en-us/library/cc645993.aspx
> <http://msdn.microsoft.com/en-us/library/cc645993.aspx>;
>
> David.
>
> On 28 May 2013 at 18:32 Paul Watson <paul@oninit.com> wrote:
> > OK I was being lazy
> >
> > Select * from prodinstance@proddb:prodtable> >
> > Where value not in (select * from uatinstance@proddb:prodtable)
> >
> > Cheers
> > Paul
> >
> > -----Original Message-----
> > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
> Art
> > Kagel
> > Sent: Tuesday, May 28, 2013 12:25 PM
> > To: ids@iiug.org
> > Subject: Re: How tu use a table on another Instance [30368]
> >
> > Those aren't distributed queries, Paul. They only reference the local
> > server.
> >
> > Art
> >
> > Art S. Kagel
> > Advanced DataTools (www.advancedatatools.com)
> > Blog: http://informix-myview.blogspot.com/
> >
> > Disclaimer: Please keep in mind that my own opinions are my own opinions
> > and do not reflect on my employer, Advanced DataTools, the IIUG, nor any
> > other organization with which I am associated either explicitly,
> > implicitly, or by inference. Neither do those opinions reflect those of
> > other individuals affiliated with any entity with which I am affiliated
> nor
> > those of the entities themselves.
> >
> > On Tue, May 28, 2013 at 1:17 PM, Paul Watson <paul@oninit.com> wrote:
> >
> > > Suspect they are many, if not all none enterprise/ultimate/whatever
> > > installations, are in breach of the license then.
> > >
> > > The simple
> > >
> > > Select * from prod where value not in (select * from uat) ;
> > > Insert into test select broken_date from prod;> > >
> > > etc
> > >
> > > are no longer allowed.
> > >
> > > Cheers
> > > Paul
> > >
> > > -----Original Message-----
> > > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
> Art
> > > Kagel
> > > Sent: Tuesday, May 28, 2013 11:44 AM
> > > To: ids@iiug.org
> > > Subject: Re: How tu use a table on another Instance [30366]
> > >
> > > And there in the Workgroup Edition and the older Growth Edition
> prohibited
> >
> > > features lists is "Distributed Operations" and "Distributed queries
> > > (I-Star)" respectively. As stated.
> > >
> > > Art
> > >
> > > Art S. Kagel
> > > Advanced DataTools (www.advancedatatools.com)
> > > Blog: http://informix-myview.blogspot.com/
> > >
> > > Disclaimer: Please keep in mind that my own opinions are my own
> opinions
> > > and do not reflect on my employer, Advanced DataTools, the IIUG, nor
> any
> > > other organization with which I am associated either explicitly,
> > > implicitly, or by inference. Neither do those opinions reflect those of
> > > other individuals affiliated with any entity with which I am affiliated
> > nor
> > > those of the entities themselves.
> > >
> > > On Tue, May 28, 2013 at 12:30 PM, Khaled Bentebal <
> > > khaled.bentebal@consult-ix.fr> wrote:
> > >
> > > > As far as what you can or cannot do on Informix licence, you can
> take a
> > > > look at the following links
> > > >
> > > > GROWTH EDITION 11.70:
> > > >
> > > >
> > > >
> > > >
> > >
> > >
> >
> http://www-03.ibm.com/software/sla/sladb.nsf/lilookup/461F2F1336373573852577
> >
> > > B900760678?opendocument&li_select=1947B9B1AC94F35E852577B900760663
> > > >
> > > > <
> > > >
> > >
> > >
> >
> http://www-03.ibm.com/software/sla/sladb.nsf/lilookup/461F2F1336373573852577
> >
> > > B900760678?opendocument&li_select=1947B9B1AC94F35E852577B900760663
> > > > >
> > > >
> > > > INNOVATOR EDITION 12.10:
> > > >
> > > >
> > > >
> > > >
> > >
> > >
> >
> http://www-03.ibm.com/software/sla/sladb.nsf/lilookup/0887266954F207D485257B
> >
> > > 39006E61E7?opendocument&li_select=ADB74C74E9DA58E285257B39006E61E4
> > > >
> > > > <
> > > >
> > >
> > >
> >
> http://www-03.ibm.com/software/sla/sladb.nsf/lilookup/0887266954F207D485257B
> >
> > > 39006E61E7?opendocument&li_select=ADB74C74E9DA58E285257B39006E61E4
> > > > >
> > > >
> > > > EXPRESS EDITION 12.10
> > > >
> > > >
> > > >
> > > >
> > >
> > >
> >
> http://www-03.ibm.com/software/sla/sladb.nsf/lilookup/B6B29948B09C326685257B
> >
> > > 39006E5C7E?opendocument&li_select=CD98439169F436CD85257B39006E5C78
> > > >
> > > > <
> > > >
> > >
> > >
> >
> http://www-03.ibm.com/software/sla/sladb.nsf/lilookup/B6B29948B09C326685257B
> >
> > > 39006E5C7E?opendocument&li_select=CD98439169F436CD85257B39006E5C78
> > > > >
> > > >
> > > > ENTERPRISE EDITION 12.10
> > > >
> > > >
> > > >
> > > >
> > >
> > >
> >
> http://www-03.ibm.com/software/sla/sladb.nsf/lilookup/398EE603D19D9DC585257B
> >
> > > 39006E4179?opendocument&li_select=2EBE7D020F3BABC185257B39006E4171
> > > >
> > > > <
> > > >
> > >
> > >
> >
> http://www-03.ibm.com/software/sla/sladb.nsf/lilookup/398EE603D19D9DC585257B
> >
> > > 39006E4179?opendocument&li_select=2EBE7D020F3BABC185257B39006E4171
> > > > >
> > > >
> > > > ADVANCED ENTERPRISE EDITION 12.10
> > > >
> > > >
> > > >
> > > >
> > >
> > >
> >
> http://www-03.ibm.com/software/sla/sladb.nsf/lilookup/4119FDE5E65F9B7B85257B
> >
> > > 39006E6A34?opendocument&li_select=6F37F7CB2DC7EEB685257B39006E6A2C
> > > >
> > > > <
> > > >
> > >
> > >
> >
> http://www-03.ibm.com/software/sla/sladb.nsf/lilookup/4119FDE5E65F9B7B85257B
> >
> > > 39006E6A34?opendocument&li_select=6F37F7CB2DC7EEB685257B39006E6A2C
> > > > >
> > > >
> > > > WORKGROUP EDITION 12.10
> > > >
> > > >
> > > >
> > > >
> > >
> > >
> >
> http://www-03.ibm.com/software/sla/sladb.nsf/lilookup/C0FBB06E64111A1E85257B
> >
> > > 39006E4FF8?opendocument&
Storage Optimization means Data/Index/Blob compression only.
Online Data and Index reorgs are included in all editions for free.
John F. Miller III
ids-bounces@iiug.org wrote on 05/28/2013 11:47:36 AM:
> From: "david@smooth1.co.uk" <david@smooth1.co.uk>
> To: ids@iiug.org,
> Date: 05/28/2013 11:50 AM
> Subject: RE: How tu use a table on another Instance [30370]
> Sent by: ids-bounces@iiug.org
>
> Can I clarify what excluding the following from 12.10 Workgroup Editi=
on
means
> "Storage Optimization Feature (Compression)"?
>
> Excluding compression I can understand but asking IBMers implies
> this excludes
> running online reorgs as well.
>
> Even the express edition of MS SQL Server 2012 which only allows 1GBo=
f
memory
> does not mention excluding online reorgs....response IBM?
>
> http://msdn.microsoft.com/en-us/library/cc645993.aspx
> <http://msdn.microsoft.com/en-us/library/cc645993.aspx>;
>
> David.
>
> On 28 May 2013 at 18:32 Paul Watson <paul@oninit.com> wrote:
> > OK I was being lazy
> >
> > Select * from prodinstance@proddb:prodtable> >
> > Where value not in (select * from uatinstance@proddb:prodtable)
> >
> > Cheers
> > Paul
> >
> > -----Original Message-----
> > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf =
Of
Art
> > Kagel
> > Sent: Tuesday, May 28, 2013 12:25 PM
> > To: ids@iiug.org
> > Subject: Re: How tu use a table on another Instance [30368]
> >
> > Those aren't distributed queries, Paul. They only reference the loc=
al
> > server.
> >
> > Art
> >
> > Art S. Kagel
> > Advanced DataTools (www.advancedatatools.com)
> > Blog: http://informix-myview.blogspot.com/
> >
> > Disclaimer: Please keep in mind that my own opinions are my own
opinions
> > and do not reflect on my employer, Advanced DataTools, the IIUG, no=
r
any
> > other organization with which I am associated either explicitly,
> > implicitly, or by inference. Neither do those opinions reflect thos=
e of
> > other individuals affiliated with any entity with which I am affili=
ated
nor
> > those of the entities themselves.
> >
> > On Tue, May 28, 2013 at 1:17 PM, Paul Watson <paul@oninit.com> wrot=
e:
> >
> > > Suspect they are many, if not all none enterprise/ultimate/whatev=
er
> > > installations, are in breach of the license then.
> > >
> > > The simple
> > >
> > > Select * from prod where value not in (select * from uat) ;
> > > Insert into test select broken_date from prod;> > >
> > > etc
> > >
> > > are no longer allowed.
> > >
> > > Cheers
> > > Paul
> > >
> > > -----Original Message-----
> > > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behal=
f Of
Art
> > > Kagel
> > > Sent: Tuesday, May 28, 2013 11:44 AM
> > > To: ids@iiug.org
> > > Subject: Re: How tu use a table on another Instance [30366]
> > >
> > > And there in the Workgroup Edition and the older Growth Edition
> prohibited
> >
> > > features lists is "Distributed Operations" and "Distributed queri=
es
> > > (I-Star)" respectively. As stated.
> > >
> > > Art
> > >
> > > Art S. Kagel
> > > Advanced DataTools (www.advancedatatools.com)
> > > Blog: http://informix-myview.blogspot.com/
> > >
> > > Disclaimer: Please keep in mind that my own opinions are my own
opinions
> > > and do not reflect on my employer, Advanced DataTools, the IIUG, =
nor
any
> > > other organization with which I am associated either explicitly,
> > > implicitly, or by inference. Neither do those opinions reflect th=
ose
of
> > > other individuals affiliated with any entity with which I am
affiliated
> > nor
> > > those of the entities themselves.
> > >
> > > On Tue, May 28, 2013 at 12:30 PM, Khaled Bentebal <
> > > khaled.bentebal@consult-ix.fr> wrote:
> > >
> > > > As far as what you can or cannot do on Informix licence, you ca=
n
take a
> > > > look at the following links
> > > >
> > > > GROWTH EDITION 11.70:
> > > >
> > > >
> > > >
> > > >
> > >
> > >
> >
http://www-03.ibm.com/software/sla/sladb.nsf/lilookup/461F2F13363735738=
52577
> >
> > > B900760678?opendocument&li_select=3D1947B9B1AC94F35E852577B900760=
663
> > > >
> > > > <
> > > >
> > >
> > >
> >
http://www-03.ibm.com/software/sla/sladb.nsf/lilookup/461F2F13363735738=
52577
> >
> > > B900760678?opendocument&li_select=3D1947B9B1AC94F35E852577B900760=
663
> > > > >
> > > >
> > > > INNOVATOR EDITION 12.10:
> > > >
> > > >
> > > >
> > > >
> > >
> > >
> >
http://www-03.ibm.com/software/sla/sladb.nsf/lilookup/0887266954F207D48=
5257B
> >
> > >
39006E61E7?opendocument&li_select=3DADB74C74E9DA58E285257B39006E61E=
4
> > > >
> > > > <
> > > >
> > >
> > >
> >
http://www-03.ibm.com/software/sla/sladb.nsf/lilookup/0887266954F207D48=
5257B
> >
> > >
39006E61E7?opendocument&li_select=3DADB74C74E9DA58E285257B39006E61E=
4
> > > > >
> > > >
> > > > EXPRESS EDITION 12.10
> > > >
> > > >
> > > >
> > > >
> > >
> > >
> >
http://www-03.ibm.com/software/sla/sladb.nsf/lilookup/B6B29948B09C32668=
5257B
> >
> > >
39006E5C7E?opendocument&li_select=3DCD98439169F436CD85257B39006E5C7=
8
> > > >
> > > > <
> > > >
> > >
> > >
> >
http://www-03.ibm.com/software/sla/sladb.nsf/lilookup/B6B29948B09C32668=
5257B
> >
> > >
39006E5C7E?opendocument&li_select=3DCD98439169F436CD85257B39006E5C7=
8
> > > > >
> > > >
> > > > ENTERPRISE EDITION 12.10
> > > >
> > > >
> > > >
> > > >
> > >
> > >
> >
http://www-03.ibm.com/software/sla/sladb.nsf/lilookup/398EE603D19D9DC58=
5257B
> >
> > >
39006E4179?opendocument&li_select=3D2EBE7D020F3BABC185257B39006E417=
1
> > > >
> > > > <
> > > >
> > >
> > >
> >
http://www-03.ibm.com/software/sla/sladb.nsf/lilookup/398EE603D19D9DC58=
5257B
> >
> > >
39006E4179?opendocument&li_select=3D2EBE7D020F3BABC185257B39006E417=
1
> > > > >
> > > >
> > > > ADVANCED ENTERPRISE EDITION 12.10
> > > >
> > > >
> > > >
> > > >
> > >
> > >
> >
http://www-03.ibm.com/software/sla/sladb.nsf/lilookup/4119FDE5E65F9B7B8=
5257B
> >
> > >
39006E6A34?opendocument&li_select=3D6F37F7CB2DC7EEB685257B39006E6A2=
C
> > > >
> > > > <
> > > >
> > >
> > >
> >
http://www-03.ibm.com/software/sla/sladb.nsf/lilookup/4119FDE5E65F9B7B8=
5257B
> >
> > >
39006E6A34?opendocument&li_select=3D6F37F7CB2DC7EEB685257B39006E6A2=
C
> > > > >
> > > >
> > > > WORKGROUP EDITION 12.10
> > > >
> > > >
> > > >
> > > >
> > >
> > >
> >
http://www-03.ibm.com/software/sla/sladb.nsf/lilookup/C0FBB06E64111A1E8=
5257B
> >
> > >
39006E4FF8?opendocument&li_selec