1.7. Federated Support
Federation allows you to query and manipulate data stored on other servers and in other RDBMSs. When you issue an SQL statement in a federated environment, you may actually be accessing information from multiple databases and potentially multiple RDBMSs (see Figure 1.10).
Federated support is included in DB2 when the other databases being accessed are part of the IBM DB2 family, that is, another DB2 database or an Informix database. For accessing databases from other vendors, refer to the IBM DB2 Information Integrator product described in section 1.9.
Get Understanding DB2®: Learning Visually with Examples now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
