Joined: 04 May 2005 Posts: 2 Location: Columbus, OH
Is there a way to join or connect tables from different databases using QMF for Windows? Here is what I'm trying to do, however, I'm getting the SQL -512 Remote Object is Invalid error when attempting to do so. I wasn't sure if there is an option that can be set within QMF for Windows to allow this or maybe the alias is specified differently??? Also, as a side note, I am connected/logged on to both databases at the time I attempt to join tables from both. Here's an example of the SQL I'm running:
SELECT A.ACCOUNT_NBR, B.ACCOUNT_NBR
FROM PRODDB.CUSTOMER_TBL A,
WHERE A.ACCOUNT_NBR = B.ACCOUNT_NBR
I'm guessing that I probably need to use some other tool to do this, like a datamining one or something. But, it would really be nice if I could do it with QMF. I'm not looking for a tool to do this, I'm just wondering if it can be done with QMF.
Joined: 17 Apr 2006 Posts: 7 Location: Kansas City
I have tried with the same type of query in our DB2 Env't. But no use, here also i am getting same problem. See the following error description :
"DSNE625I CONNECT TO LOCATION 'DBOUDVL' PERFORMED, SQLCODE IS 950
DSNT408I SQLCODE = -950, ERROR: THE LOCATION NAME SPECIFIED IN THE CONNECT STATEMENT IS INVALID OR NOT LISTED IN THE COMMUNICATIONS DATABASE ".
There is an option called " CONNECT LOCATION " for For remote SQL processing. I have given the option and tried with that. But those Location names should be defined in our communications DBase. So better to contact your DBA guys or your manager. They can help you.
We can do this remote sql query processing. There is no doubt. But some env't setting problems. Try to find the correct remote location names and try that.