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 employer. For example, WebSphere Message Broker for z/OS includes an ODBC driver, and that would be a very elegant and extensible approach which would reduce or eliminate programming burden in the short and long term. More information here: http://www.ibm.com/software/integration/wbimessagebroker Another possibility is to install TXSeries for Windows on the SQL Server machine (or at least on a machine in close proximity). TXSeries for Windows is capable of issuing an EXEC SQL call into SQL Server. You could use EXEC CICS LINK on the CICS Transaction Server side for the CICS to TXSeries interoperations, so that's very straightforward, too. The assumption of course is that you have CICS Transaction Server for z/OS. I think Attunity has a client ODBC driver for z/OS (for CICS specifically), although I don't know much about its status. I found a brief mention here: http://www.attunity.com/forums/cics-adapters/odbc-client-interface-under-cics-os-240.html There are some non-ODBC options, too, but I'll stop there for now. Hope that helps! - - - - - Timothy Sipples Resident Enterprise Architect Value Creation & Complex Deals Team IBM Growth Markets (Based in Singapore) E-Mail: [email protected] ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
