Install isql with informix?

Posted on 2012-08-15
Medium Priority
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 is...how 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
  • 2
  • 2
LVL 18

Expert Comment

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

Author Comment

ID: 38298546
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 18

Accepted Solution

Garry Glendown earned 2000 total points
ID: 38299282
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

ID: 38301334

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

Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this blog post, we’ll look at how using thread_statistics can cause high memory usage.
Backups and Disaster RecoveryIn this post, we’ll look at strategies for backups and disaster recovery.
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses

862 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