Informix

 View Only
  • 1.  Informix GUI Tools

    Posted Mon November 04, 2019 12:47 AM
    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


  • 2.  RE: Informix GUI Tools

    Posted Mon November 04, 2019 05:02 AM

    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
    ------------------------------



  • 3.  RE: Informix GUI Tools

    Posted Mon November 04, 2019 07:19 PM
    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
    ------------------------------



  • 4.  RE: Informix GUI Tools

    IBM Champion
    Posted Mon November 04, 2019 06:33 AM
    SangGyu:

    The tools you mentioned are all good ones. Most GUI SQL tools will work with Informix, though to get best support from some you may have to implement the standard ODBC catalog tables.

    Art

    Art S. Kagel, President and Principal Consultant
    ASK Database Management


    Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference.  Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves.