iSeries DB2 - SQL GUI Tool

Question

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.

score 2 · Accepted Answer · answered Jul 04 '11 at 10:22

2

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.

answered Jul 04 '11 at 10:22

jax

207
2
5
12

score 2 · Answer 2 · edited Jun 11 '20 at 10:02

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.

edited Jun 11 '20 at 10:02

Community

1

answered Jul 04 '11 at 15:05

jamesallman

695

score 2 · Answer 3 · answered Nov 16 '11 at 18:04

2

IBM provides IBM Data Studio at no charge. http://www-01.ibm.com/software/data/optim/data-studio/

answered Nov 16 '11 at 18:04

MrG

143
5

score 0 · Answer 4 · answered Feb 14 '14 at 11:15

0

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

answered Feb 14 '14 at 11:15

Zo Has

101

iSeries DB2 - SQL GUI Tool

4 Answers4