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 O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.