Is there a way to access the SQL Server Database without using DB2 Integrator or WEBSPHERE Integrator? Can it be done using Java?
Yes. If your programmers have Java skills, you can use Java, but it requires a JDBC type-4 driver for SQL Server. Microsoft provides such a driver, and it can be downloaded from their Web site. Extra middleware is required because SQL Server does not fully support the open group Distributed Relational Database Architecture (DRDA) standard for remote database access and interoperability like DB2 for i5/OS.
This was first published in February 2008