Evaluate Weigh the pros and cons of technologies, products and projects you are considering.

Access data in SQL Server from the iSeries

IBM's Kent Milligan shows you how to access data in Microsoft SQL Server from an iSeries program.

Can you tell me what I need to access data in a MS SQL database from the iSeries?

The white paper you are looking for is Heterogeneous Data Access for iSeries Applications.

To access a non-DB2 data source (including Microsoft SQL Server) from an iSeries program written in any high-level programming language, use WebSphere Information Integrator (Formerly DB2 Information Integrator - DB2 II). This product requires that the data access to be performed with an SQL-based interface such as CLI, embedded SQL, or JDBC.

Dig Deeper on DB2 UDB (universal databases)

Join the conversation


Send me notifications when other members comment.

Please create a username to comment.

The link is not valid. IBM changes their site all the time, linking to content there is hazardous.