Hi all,

I'm curious what tools users who use Informix DB use when running SQL in a GUI environment.

Until now, when I visited a client, their developers and system administrators were using programs such as Aqua Data Studio, AGS Server Studio, DBeaver, Squirrel SQL, and WinSQL. Of course, some users use DB-access in a terminal window.

I'm usually used to Terminal screen, so I rarely use GUI tools(I love Cygwin), but customers are always asking if there are any tools that are more convenient than they are currently using.

My personal opinion is that IBM Data Studio is a good alternative, but it feels heavier in terms of runtime or installation capacity than the tools mentioned above. And the feature to view Informix explain plans seems to be limited compared to Db2.

Are there any other GUI tools except those mentioned above?

------------------------------
SangGyu Jeong
Software Engineer
Infrasoft
Seoul Korea, Republic of
------------------------------

#Informix

One not in the list is DBVisualizer (DbVisualizer).
One additional note:

You can get text explains from queries in any Informix version currently supported (and some more - 9.1+), while using ANY tool by following some relatively simple steps:

Execution plans on the client / Planos de execução nos clientes

Informix-technology		remove preview
Execution plans on the client / Planos de execução nos clientes This article is written in Englsih and Portuguese Este artigo está escrito em Inglês e Português Life is full of coincidences... Because IIUG announced the 2013 IIUG user's conference, to be held in Sand Diego on 21-25 April, I spent some time reviewing my 2010 presentation. View this on Informix-technology >

Regards.

------------------------------
FERNANDO NUNES
------------------------------

Oops ... I missed DBVisulalizer.
I've seen your get_explain routine before. Thank you for letting me know.

------------------------------
SangGyu Jeong
Software Engineer
Infrasoft
Seoul Korea, Republic of
------------------------------

Original Message:
Sent: Mon November 04, 2019 05:01 AM
From: FERNANDO NUNES
Subject: Informix GUI Tools

One not in the list is DBVisualizer (DbVisualizer).
One additional note:

You can get text explains from queries in any Informix version currently supported (and some more - 9.1+), while using ANY tool by following some relatively simple steps:

Execution plans on the client / Planos de execução nos clientes

Informix-technology		remove preview
Execution plans on the client / Planos de execução nos clientes This article is written in Englsih and Portuguese Este artigo está escrito em Inglês e Português Life is full of coincidences... Because IIUG announced the 2013 IIUG user's conference, to be held in Sand Diego on 21-25 April, I spent some time reviewing my 2010 presentation. View this on Informix-technology >

Regards.

------------------------------
FERNANDO NUNES
------------------------------

------Original Message------

Hi all,

I'm curious what tools users who use Informix DB use when running SQL in a GUI environment.

Until now, when I visited a client, their developers and system administrators were using programs such as Aqua Data Studio, AGS Server Studio, DBeaver, Squirrel SQL, and WinSQL. Of course, some users use DB-access in a terminal window.

I'm usually used to Terminal screen, so I rarely use GUI tools(I love Cygwin), but customers are always asking if there are any tools that are more convenient than they are currently using.

My personal opinion is that IBM Data Studio is a good alternative, but it feels heavier in terms of runtime or installation capacity than the tools mentioned above. And the feature to view Informix explain plans seems to be limited compared to Db2.

Are there any other GUI tools except those mentioned above?

------------------------------
SangGyu Jeong
Software Engineer
Infrasoft
Seoul Korea, Republic of
------------------------------

#Informix