Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Can someone suggest a good free Database tool with SQL support for connection to an iSeries. Currently I am using the green screen and it is quite frustrating.

share|improve this question
Could you elaborate what you mean a bit? Do you mean something like WRKDBF or WRKQRY or do you want an app on your computer similar to phpMyAdmin or SQL Server Management Studio? I'm thinking the latter, but clarification might help people to better answer your question. – Ben Pilbrow Jul 2 '11 at 9:59
An app on my computer (Windows XP), much like sqlDbx ( but free for commercial use – jax Jul 2 '11 at 10:09
up vote 2 down vote accepted

From my own research SQuirreL SQL is the best open source GUI client for the iSeries. It tried it out today it it worked nicely, code completion, syntax highlighting etc.

share|improve this answer

I highly recommend DbVisualizer with the IBM Toolbox/JTOpen database driver. You can also use it to connect to almost any other database as well. It's cross platform and runs on Linux, Mac OS X, and Windows.

There is a Free edition edition for commercial and non-commercial use.

DbVisualizer Screenshot

share|improve this answer

IBM provides IBM Data Studio at no charge.

share|improve this answer

IBM i Client Access does a good job with most of the requirements.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.