How to connect to DB2 on iSeries / AS400

RazorSQL can connect to iSeries via ODBC or JDBC. The JDBC connection requires the download of an additional JDBC driver.

If you are on a Windows machine, the easiest way to connect is probably via ODBC. You would need to obtain the iSeries Access for Windows client from IBM and set up an ODBC datasource on your machine. RazorSQL can then use the datasource to connect to DB2.

There is an open source JDBC driver available for AS400 / iSeries called jtopen. RazorSQL can use this driver to connect to DB2. More information on the driver is available from here:

JTOpen JDBC Driver