Running a query on 2 differnt schemas in PMI

Archived Topics
1

Is it possible to run a query in PMI on differnt schemas or run 1 query on 2 diffent data sources.

2

You can’t run one query on two different data sources, but most (all?) database will allow you to specify different schemas in one query, like this:

SELECT A, B FROM Schema1.MyTable, Schema2.MyOtherTable

Hope this helps,

3

Could you describe what you’re trying to accomplish?

I took this to refer to INSERT or UPDATE queries on multiple datasources. Carl answered the question for binding or SELECT queries.

You can run the same query against different datasources by running it separately. This would be accomplished in script with Jython.