Re: COBOL to SQL server

2011-05-10 Thread Timothy Sipples
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

Re: COBOL to SQL server

2011-05-10 Thread Jan MOEYERSONS
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.

Re: COBOL to SQL server

2011-05-09 Thread Jim McAlpine
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

COBOL to SQL server

2011-05-06 Thread Jim McAlpine
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

Re: COBOL to SQL server

2011-05-06 Thread Roberto Halais
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

Re: COBOL to SQL server

2011-05-06 Thread Barkow, Eileen
, 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

Re: COBOL to SQL server

2011-05-06 Thread Frank Swarbrick
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:

Re: COBOL to SQL server

2011-05-06 Thread Frank Swarbrick
@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

Re: COBOL to SQL server

2011-05-06 Thread Schneck.Glenn
- 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

Re: COBOL to SQL server

2011-05-06 Thread Rozeboom, Kay [DAS]
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