Unable to create heterogeneous query for DB2.
Example:
1. Connected to a DB2 server using DB2 native client.
2. Add a table to query builder.
3. Now connect to a different DB2 server and attempt to add a table into query builder. The table cannot be dragged into the Query Builder pane.
This also occurs if trying to create a heterogenous query with a DB2 table and any other DB type e.g DB2 join to Oracle table, DB2 join to SQL Server table
WORKAROUND
Create and connect using ODBC DB2:
From Navigator Manager:
1. Right Click on ODBC group | New | Create a new data source name by clicking the 'Open ODBC Data Source Administrator' icon
2. Select User DSN tab
3. Add | Select IBM DB2 ODBC DRIVER - TACOM11 | Finish
4. Type in a Data Source Name
5. Select a DB2 alias (or create a new one using the ADD button)
6. OK
Now make a connection(s) to DB2 using the ODBC data source and continue with creation of heterogeneous query
STATUS
Waiting for fix in future release of Toad for Data Analysis
