The ability to create a DataWindow based on a heterogeneous cross-database join is available through the use of Adaptive Server’s Component Integration Services. Component Integration Services allow you to connect to multiple remote heterogeneous database servers and define multiple proxy tables that reference the tables residing on those servers.
For information on how to create proxy tables, see the Adaptive Server documentation. For information on identifying identity columns in the underlying database tables referenced by proxy tables, see the technical note “Techniques for Working with Identity Columns in SQL Anywhere Proxy Tables” on the Sybase Web site.
