I want to execute a query on a table which is located on a different subsystem. I have two TSO regions for example t1 and t2. Db2 subsystems db1 and db2. I want to execute a query which is on db2 fromn t1. Please guide me..
I tried to save the query as a proc in QMF and tried to run it from t1 but it is not succesful.. Please help me if there is any other procedure to do it..
Please find out if the DDF connections are setup between the two subsystems. If they are setup already, you can use Locationid.qualifier.tablename for getting data from the table of other system.
Thanks alot for the help.. One more thing, if the DDF connections are available then do we need to give any connect statements while executing through a batch job? or directly can we use that db2 subsystem name.