Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
QMF for Windows - Connecting Remote Objects using SQL

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
rayandqmf

New User


Joined: 04 May 2005
Posts: 2
Location: Columbus, OH

PostPosted: Wed May 04, 2005 7:05 pm    Post subject: QMF for Windows - Connecting Remote Objects using SQL
Reply with quote

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,
DEVDB.CUSTOMER_TBL B
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.
Back to top
View user's profile Send private message

chandu_605k

New User


Joined: 17 Apr 2006
Posts: 7
Location: Kansas City

PostPosted: Fri Apr 21, 2006 6:10 pm    Post subject: Re: QMF for Windows - Connecting Remote Objects using SQL
Reply with quote

Dear Friend(s),
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.

Best Wishes...
CSR
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts JES2 job size field matching Windows ... SRICOBSAS All Other Mainframe Topics 4 Tue Sep 05, 2017 5:49 pm
No new posts Delete IMS remote transaction when MO... Sam Singh IMS DB/DC 0 Wed Aug 23, 2017 9:12 pm
No new posts FTP from windows server into Mainfram... sathyajes All Other Mainframe Topics 24 Wed Jul 20, 2016 1:33 pm
No new posts problem on data conversion from windo... hkalhor2 Java & MQSeries 3 Tue May 17, 2016 12:10 pm
No new posts force windows ftp client user to defa... meykh2014 All Other Mainframe Topics 0 Sun Feb 14, 2016 12:57 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us