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 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
No new posts Rexx to send an email without SMTP Se... upendrasri All Other Mainframe Topics 12 Sun Nov 19, 2017 7:59 pm
No new posts Technical Support Engineer (DB2 on z/... Kenneth Barton Lasky Mainframe Jobs 0 Fri Aug 25, 2017 12:14 am
No new posts Liberty Angel Server using RACF Keyring martin9 CICS 0 Tue May 02, 2017 5:49 pm

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