Select the "Conductor" link in the Left Frame and Login as the
Figure 8.274. Conductor
Select the "Databases" -> "External Data Source" -> "Data
Sources" tab menu items
Figure 8.275. Databases
Select the "Connect" button for the "db2v8ma" DB2 DSN.
Figure 8.276. Connect
On successful connection Select the "Link Objects" button to
obtain a list of available tables
Figure 8.277. Link
Select the tables that you would like to link.
Figure 8.278. Select
Change the Catalog for each table to be "SAMPLE" using the "Set
Figure 8.279. Catalog
All the catalog names are changed to be "SAMPLE".
Figure 8.280. catalog
Select the "Link" button to link the selected tables into
Figure 8.281. "Link"
On completion of the Link process the tables will be displayed
in the "External Linked Objects" tab.
Figure 8.282. Completion
The linked tables can be queried by clicking on the hyperlink in
the Local Name column of the External Linked Objects tab above.
This loads the Virtuoso Interactive SQL interface with the required
SQL Select for retrieving the remote table data . We shall use the
SAMPLE.db2v8ma.EMPLOYEE table to demonstrate this.
Figure 8.283. view
Click the Execute button to run the query and retrieve the
results from the remote table.
Figure 8.284. Execute
The tables can also be viewed as part of the Virtuoso SQL Schema
Objects under the SAMPLE catalog name.
Figure 8.285. SQL Schema
The Link process is now complete enabling the tables to be
queried as if part of the Virtuoso Schema.