I have been searching the Sybase Online help and searched for union in
v11.9.2 and under New Functionality in Adaptive Server Enterprise 11.9.2
it had an example:
Statements involving the union operator, where the select statement on
one side of the union references tables that reside on a different server
than the select statement on the other side of the union. Quickpass mode
analyzes each side of the union, and sends each individual select statement
to a remote server if possible. For example, the following query is a union
between Oracle and DB2 tables:
select name, sum(salary) as salary from oracle_t1, oracle_t2 where
oracle_t1.id = oracle_t2.id group by name union select name, sum(salary) as
salary from db2_t1, db2_t2 where db2_t1.id = db2_t2.id group by name
Is this a patch or an upgrade for 11.9.2?
-Gerard
v11.9.2 and under New Functionality in Adaptive Server Enterprise 11.9.2
it had an example:
Statements involving the union operator, where the select statement on
one side of the union references tables that reside on a different server
than the select statement on the other side of the union. Quickpass mode
analyzes each side of the union, and sends each individual select statement
to a remote server if possible. For example, the following query is a union
between Oracle and DB2 tables:
select name, sum(salary) as salary from oracle_t1, oracle_t2 where
oracle_t1.id = oracle_t2.id group by name union select name, sum(salary) as
salary from db2_t1, db2_t2 where db2_t1.id = db2_t2.id group by name
Is this a patch or an upgrade for 11.9.2?
-Gerard