JDBC data

[peteshnick]

Hi,

Sorry if this has been addressed before - I couldn't find it in a quick search. I'm connecting to a DB2 database via JDBC, but I want to do some queries where I pull in data from tables on my local machine. I don't want to add a new table to the remote database (which it seems like will happen if I just blindly create a table), so I am thinking I need to pull the local data (stored in a different local database) in via a query (or vice versa). The problem is, I can't figure out how to create a query (in design view or sql view) that pulls data from a different database on my local machine.

Any help would be appreciated. Thank you!