Application programs
Applications do not require any special coding to work with federated data. Applications access the system just like any other database client application. Applications interface with the federated database that is within the federated server.
To obtain data from data sources, applications submit queries in
SQL to the federated database. The federated database then distributes
the queries to the appropriate data sources, collects the requested
data, and returns this data to the applications. However, since the
federated database interacts with the data sources through nicknames,
you need to be aware of:
- The SQL restrictions you have when working with nicknames
- How to perform operations on nicknamed objects