iSeries DB2 - SQL GUI Tool
9,083
Solution 1
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.
Solution 2
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.
Solution 3
IBM provides IBM Data Studio at no charge. http://www-01.ibm.com/software/data/optim/data-studio/
Related videos on Youtube
Author by
user3453202
Updated on September 18, 2022Comments
-
user3453202 over 1 year
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.
-
Ben Pilbrow almost 13 yearsCould 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.
-
user3453202 almost 13 yearsAn app on my computer (Windows XP), much like sqlDbx (sqldbx.com) but free for commercial use
-