Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rsjrny
Starting Member
1 Post |
 Posted - 2011-10-19 : 09:20:18
|
| I currently access a DB2 database from a Z/OS environment using REXX scripts and a DSNREXX connections. The database is moving from the mainframe to a Windows 2008 R2 Server. I am looking for some direction as to what I may need to access the SQL Server data from my Mainframe environment. Many years ago I had a similar project where I used OSQL on the server which was remotely executed using an ASG product called Outbound and this worked okay.Since that was many years ago I am hoping access methods have changed enough that there may be a better way to handle the queries and return the data.Requirements:1) From the Mainframe send a request to Sql Server to execute the SQL. I have a need to Update the database and also retrieve data.2) return the results from the SQL to the mainframe.I am a mainframe developer and would like to keep as much of the code as possible on the mainframe.Thanks in advance for all your help. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-10-19 : 09:36:24
|
| read about linked servers------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
Accessing SQL Server Database from Z/OS Mainframe