Database connection from MVS / z/OS to SQL server (via ODBC or native)
IBM provides a way to connect to DB2 databases from Open world : DB2connect.
DB2connect authenticates a client, and handles eventual EBCDIC / ASCII-UNICODE conversions.
Oracle has a product (Access Manager for CICS) that allows CICS transactions
I am looking for a similar product that would give z/OS programs (typically COBOL programs) running into JES2 / CICS access to MicroSoft SQL server.
To summarize, I'm looking for an equivalent of ODBC connectivity for z/OS
Thank you, guys.
DB2connect authenticates a client, and handles eventual EBCDIC / ASCII-UNICODE conversions.
Oracle has a product (Access Manager for CICS) that allows CICS transactions
I am looking for a similar product that would give z/OS programs (typically COBOL programs) running into JES2 / CICS access to MicroSoft SQL server.
To summarize, I'm looking for an equivalent of ODBC connectivity for z/OS
Thank you, guys.
All you have to do is pickup the JDBC driver you need for CICS and connect with it to SQl server.
I have provided the list of JDBC drivers you can work with in the previous post.
Have a good day.
I have provided the list of JDBC drivers you can work with in the previous post.
Have a good day.
ASKER
That's not so simple :
I don't want to communicate with SQL Server from Unix System Services (USS), but from CICS COBOL transactions or from COBOL batches launched within JES2.
I need to open a DB connection to SQL Server from CICS or JES2, in order to access an SQL server database.
I don't want to communicate with SQL Server from Unix System Services (USS), but from CICS COBOL transactions or from COBOL batches launched within JES2.
I need to open a DB connection to SQL Server from CICS or JES2, in order to access an SQL server database.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I believe that MS provides a type 4 JDBC driver for SQL server. If you are running Java in your CICS you may be able to use this.
At one time MS talked about adding DRDA support to MS SQL server, I don't know if they ever did. If they did, then you could define the SQL data base as a remote database to DB2 on z/OS (assuming you have DB2 on z/OS) and then access the data that way.
Not sure how to do this in batch mode, unless MS has added DRDA support.
At one time MS talked about adding DRDA support to MS SQL server, I don't know if they ever did. If they did, then you could define the SQL data base as a remote database to DB2 on z/OS (assuming you have DB2 on z/OS) and then access the data that way.
Not sure how to do this in batch mode, unless MS has added DRDA support.
ASKER
Thank you qiltjr but JDBC is Java related and Java also means USS (JES2 & CICS use to run COBOL or PL/I progs). I also heard about this DRDA linked database, meaning that your progs talk to DB2 but your requests are forwarded to a remote database.
But I feel that my solution is located around Host Integration Server (HIS), around "Host Initiated Process".
Anybody already used this and has architecture samples to provide me ?
But I feel that my solution is located around Host Integration Server (HIS), around "Host Initiated Process".
Anybody already used this and has architecture samples to provide me ?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you guys for your help. It seems that I have to build my own gateway using HIS or so.
I will split awarded points between both of you as you both tried to help.
I will split awarded points between both of you as you both tried to help.
ASKER
Still some work to do before hitting target...
https://www.experts-exchange.com/questions/10526821/JDBC.html?sfQueryTermInfo=1+cic+connect+server+sql