Starting SQL builder

Use the graphical interface of SQL builder to construct SQL queries that run against federated databases.

1. In the Reference Provider pane, click Browse. The Browse Providers dialog box opens.
2. In the Select a Reference Provider type list, select Federation Server. In the Select a Federated Datasource tree, the list of database aliases opens.
3. Click a database alias. The list of schemas opens as nodes beneath each database alias.
4. In the SQL Type list, select the type of SQL query that you want to construct.
5. Click the SQL builder button. The SQL Builder - Db2 / UDB 8.2 window opens. In the Select Tables pane, the database alias appears as a node.