Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Directly connect SQL server through mf

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

New User


Joined: 26 Apr 2007
Posts: 49
Location: Delhi

PostPosted: Mon Mar 10, 2008 5:33 pm    Post subject: Directly connect SQL server through mf
Reply with quote

Hi

Can we directly connect Windows SQL server through mainframe.
If it is possible, please let me know how is that possible.

Thanks
Back to top
View user's profile Send private message

stodolas

Active Member


Joined: 13 Jun 2007
Posts: 632
Location: Wisconsin

PostPosted: Mon Mar 10, 2008 6:33 pm    Post subject:
Reply with quote

It is possible, but not with Cobol alone.

I know that WAS running on a mainframe can have connection built to a SQL Server through java libraries. I am assuming a batch java program could also do the same thing using the Microsoft drivers in some fashion.
Back to top
View user's profile Send private message
Mahua Mitra

New User


Joined: 26 Apr 2007
Posts: 49
Location: Delhi

PostPosted: Thu Mar 13, 2008 3:13 pm    Post subject:
Reply with quote

To breif my requirement:
The DB is presentmy sybase and there are certain jobs which are excuetd to process data in sybase. Now Sybase is migrated to SQL server in Windows. We would like to use the same jobs for processing the data in SQL server as well.

So is it possible. If yes, what will be the best way to do it.

Thanks
Back to top
View user's profile Send private message
stodolas

Active Member


Joined: 13 Jun 2007
Posts: 632
Location: Wisconsin

PostPosted: Thu Mar 13, 2008 5:32 pm    Post subject:
Reply with quote

You can't unless you can find someone who wrote a SQL Server connector for a mainframe. I have looked a few times and never found one. I don't think it is going to work.
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 Liberty Angel Server using RACF Keyring martin9 CICS 0 Tue May 02, 2017 5:49 pm
No new posts Connect:Direct - RC=000000FF MSG=SVTM... R.Manivannan All Other Mainframe Topics 3 Fri Apr 21, 2017 1:30 am
No new posts FTP Server and FTP.DATA vasanthz All Other Mainframe Topics 2 Wed Oct 12, 2016 11:49 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 DB2 CONNECT query mistah kurtz DB2 3 Fri Jul 15, 2016 6:37 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us