IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Directly connect SQL server through mf


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
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
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
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
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
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts Connect Direct 6.3 for Z/OS All Other Mainframe Topics 20
No new posts Call program, directly from panel CLIST & REXX 9
No new posts Getting TWA in CICS program while con... CICS 14
No new posts Z Monitoring server fails to start IBM Tools 1
No new posts Unable to connect FTP over TLS from z... All Other Mainframe Topics 5
Search our Forums:

Back to Top