Selecting data in a federated system
How you select data in a federated systems depends on the type of data source that you select from.
Some of the types of distributed requests used with a federated
system are requests that query:
- A single remote data source
- A local data source and a remote data source
- Multiple remote data sources
- A combination of remote and local data sources
To select data from the data sources, use the nicknames for the data source objects in the SELECT statement.
The federated database is a local data source. Tables and views in the federated database are local objects. You do not create nicknames for these objects, you use the actual object name in the SELECT statements.
Remote data sources include: another Db2® database instance on the federated server, another Db2 database instance on another server, and other data sources. Objects that reside on remote data sources are remote objects.