There are just a few ways to connect to Microsoft SQL Server. The most
common is a protocol called ODBC. There are JDBC to ODBC bridges
available, and that would be one option. But that might be a bit Rube
Goldbergesque for some.
There are some vendors of ODBC drivers for z/OS. One of them is my
On Mon, 9 May 2011 09:59:09 +0100, Jim McAlpine
jim.mcalp...@gmail.com wrote:
No one has mentioned JDBC, is it possible to use that. We can invoke a Java
program from COBOL. Anyone ever done something like that ?
Yes, we run a few batch jobs where COBOL code invokes methods on Java
objects.
No one has mentioned JDBC, is it possible to use that. We can invoke a Java
program from COBOL. Anyone ever done something like that ?
Jim McAlpine
--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email
cross posted to DB2 list.
Does anyone know if it is possible to issue some SQL from a batch COBOL
program running on z/OS to an SQL Server database.
Jim McAlpine
--
For IBM-MAIN subscribe / signoff / archive access
I think you can do it using ODBC.
http://msdn.microsoft.com/en-us/library/aa266544(v=vs.60).aspx
http://msdn.microsoft.com/en-us/library/aa266544(v=vs.60).aspxBut you must
check IBM's implementation of ODBC
On Fri, May 6, 2011 at 7:01 AM, Jim McAlpine jim.mcalp...@gmail.com wrote:
cross posted
, May 06, 2011 8:41 AM
To: IBM-MAIN@bama.ua.edu
Subject: Re: COBOL to SQL server
I think you can do it using ODBC.
http://msdn.microsoft.com/en-us/library/aa266544(v=vs.60).aspx
http://msdn.microsoft.com/en-us/library/aa266544(v=vs.60).aspxBut you must
check IBM's implementation of ODBC
On Fri, May 6
You can use Infosphere Federation Server. We do this to access Oracle
databases, but Federation Server supports many database types.
Costs $$$ of course...
--
Frank Swarbrick
Applications Architect - Mainframe Applications Development
FirstBank Data Corporation - Lakewood, CO USA
P:
@bama.ua.edu
Subject: Re: COBOL to SQL server
I think you can do it using ODBC.
http://msdn.microsoft.com/en-us/library/aa266544(v=vs.60).aspx
http://msdn.microsoft.com/en-us/library/aa266544(v=vs.60).aspxBut you must
check IBM's implementation of ODBC
On Fri, May 6, 2011 at 7:01 AM, Jim McAlpine
- Monday, Tuesday, Friday
WFH - Wednesday, Thursday
Live Solid. Bank Solid.
From: IBM Mainframe Discussion List on behalf of Frank Swarbrick
Sent: Fri 5/6/2011 11:01 AM
To: IBM-MAIN@bama.ua.edu
Subject: Re: COBOL to SQL server
I believe DB2 Connect
to buy.
-Original Message-
From: IBM Mainframe Discussion List [mailto:IBM-MAIN@bama.ua.edu] On Behalf Of
Jim McAlpine
Sent: Friday, May 06, 2011 6:02 AM
To: IBM-MAIN@bama.ua.edu
Subject: COBOL to SQL server
cross posted to DB2 list.
Does anyone know if it is possible to issue some SQL
10 matches
Mail list logo