Working with the Federated Data
This section describes how to access and update data at the data sources:
Working with nicknames
Transaction support in a federated system
Selecting data in a federated system
Modifying data in a federated system
Working with Nicknames
When you want to select or modify data source data, you query the nicknames using the SELECT, INSERT, UPDATE, and DELETE statements. You submit queries in DB2 SQL to the federated database. You can join data from local tables and remote data sources using a single SQL statement, as though all the data were local. For example, you can join data that is located in:
A local DB2 for Windows table in the federated database, an Oracle table, and a Sybase view
A DB2 for z/OS table on one server, ...
Get Advanced DBA Certification Guide and Reference for DB2® Universal Database™ v8 for Linux®, UNIX®, and Windows® 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.
