Technote (FAQ)
Question
What is needed to set up Informix-SQL (I-SQL) ?
Cause
Documentation for the install and setup process is limited.
Answer
There are a few parts needed to enable use of I-SQL with IBM Informix Dynamic Server.
- Set the INFORMIXDIR environment variable to the path where you are installing I-SQL. This should be a separate directory from the database server software.
- Install the I-SQL software.
- To use the I-SQL software, set the following environment variables:
-
INFORMIXSERVER= your database instance
INFORMIXSQLHOSTS = the full path to your sqlhosts file.
PATH = $INFORMIXDIR/bin:/other_paths...
-
(note that isql is a generic command file on some operating systems. Make sure the Informix/bin reference is first.)
A library path is needed also. The variable to use will depend on your Operating System, usually:
-
LD_LIBRARY_PATH = <INFORMIXDIR>/lib:<INFORMIXDIR>/lib/tools:<INFORMIXDIR>/lib/esql
for AIX or HP-UX:
-
SHLIB_PATH = <INFORMIXDIR>/lib:<INFORMIXDIR>/lib/tools:<INFORMIXDIR>/lib/esql
Rate this page:
Average rating
Copyright and trademark information
IBM, the IBM logo and ibm.com are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml.