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
 
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 IBM HTTP web server - redirect http t... vasanthz All Other Mainframe Topics 4 Thu May 17, 2018 12:32 am
No new posts Connect Direct - using DEBUG=TRACE Bits srajendran2 All Other Mainframe Topics 4 Tue May 08, 2018 3:08 am
No new posts Defining SSL Port in TCPIP for DB2 Se... Yolanda Harvey TSO/ISPF 1 Wed Mar 28, 2018 7:33 pm
No new posts CICS EZASOKET CONNECT using DNS name ankit.jain CICS 1 Tue Jan 16, 2018 7:24 pm
No new posts Migrating Java application from JVM p... danik56 CICS 0 Sat Dec 23, 2017 1:42 pm

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