I have installed the most recent versions of Squirrel SQL Client (V3.5) and the iSeries/AS400/System i/i5 (whatever we call it this week!) JDBC driver, JTOpen V7.9. I can happily connect to our iSeries and run SQL statements successfully. In the Object window view, I get a list of schemas (aka libraries) and can expand the list of object types. However, when I try to expand the beyond the object types (e.g. by double clicking on the TABLE entry), the list of tables is always empty. In contrast, when I use the JDBC-ODBC Bridge driver to connect the iSeries, the tables will all appear as expected in the Object window.
Log in to post a comment.