Creating and using federated views

A view in that includes a reference to a nickname in the fullselect is a federated view. The base tables are referenced in the federated view using nicknames, instead of using the data source table names.

About this task

Restrictions

Federated views that are created from multiple data source objects are read-only views and cannot be updated.

Federated views that are created from only one data source object might or might not be read-only views.
  • A federated view created from a single nonrelational data source is read-only.
  • A federated view created from a single relational data source might allow updates, depending on what is included in the CREATE VIEW statement.

About this task

The advantages of using federated views are similar to the advantages of using views defined on local tables in a centralized relational database manager:
  • Views provide an integrated representation of the data
  • You can exclude table columns that contain confidential or sensitive data from a view

Procedure

You create a federated view from data source objects that have nicknames. The action of creating a federated database view of data source data is sometimes called creating a view on a nickname. This phrase reflects the fact that for the federated view to be created, the CREATE VIEW statement fullselect must reference the nickname of each data source table and view that the federated view is to contain.