Install isql with informix?

Posted on 2012-08-15
Last Modified: 2013-12-25
Good day experts

I previously installed IBM Informix Dynamc Server, Version 11.50.FC8 under Linux SLES 10 SP2.

Users are asking for a utility called isql to create forms in that server. I'm new to informix, so I really don't know what they're referring to. I did a search on every fs to look if there was any isql command in the informix installation directory but couldn't find it.

I looked up some docs and now I know this is a utility for doing some Interactive SQL statements from the command line, including the creation of forms.

I also read that dbaccess does NOT support report or forms (I guess that's why they're needing isql)...Also that another option to generate reports is the smformbld command, but couldn't find that either on my server.

The question do I get this installed and configured (isql) on my server? Is this part of the IBM IDS package installation or is this utility downloaded from a third party?

Thanks in advance
Question by:Arrismog
    LVL 17

    Expert Comment

    Formerly, isql was just another product that had to be installed just like other stuff like the backend, 4gl runtime/development, etc ...

    Author Comment

    Hi Gerry-G

    So I'm assuming that isql isn't included in the IBM Informix Dynamic Server installation package...where do I get it? is it free or does it require any license? I also tried searching it in my yast repositories but couldn't find it there either :S!

    Thanks in advance
    LVL 17

    Accepted Solution

    Not sure whether there is a free license available for certain usage, but here's the IBM page where you could get a quote or order licenses ...

    Author Closing Comment


    Thanks for the info! indeed, it seems that the informix suite is "the" utility for creating forms "...The Informix SQL suite includes a schema editor, menu builder, SQL editor, forms builder, and report writer..." I'll check if this is a license-based utility or not, meanwhile I'll close this thread...and if I find anything else, I'll open a new question :P

    Thanks a lot Gerry-G

    Featured Post

    6 Surprising Benefits of Threat Intelligence

    All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

    Join & Write a Comment

    Entering time in Microsoft Access can be difficult. An input mask often bothers users more than helping them and won't catch all typing errors. This article shows how to create a textbox for 24-hour time input with full validation politely catching …
    Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
    Learn how to get help with Linux/Unix bash shell commands. Use help to read help documents for built in bash shell commands.: Use man to interface with the online reference manuals for shell commands.: Use man to search man pages for unknown command…
    Learn how to navigate the file tree with the shell. Use pwd to print the current working directory: Use ls to list a directory's contents: Use cd to change to a new directory: Use wildcards instead of typing out long directory names: Use ../ to move…

    746 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now