Summary

With a federated system you can send distributed requests to multiple data sources within a single SQL statement. The power of a DB2 federated system is in its ability to:

• Join data from local tables and remote data sources, as if all the data are local.

• Take advantage of the data source processing strengths by sending distributed requests to the data sources for processing.

• Compensate for SQL limitations at the data source by processing parts of a distributed request at the federated server.