Skip to main content

How to set up I-SQL?


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.

  1. 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.
  2. Install the I-SQL software.
  3. 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:

(0 users)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.

Rate this page:


(0 users)Average rating

Add comments

Document information

Informix Tools

Informix SQL (I-SQL)


Software version:
11.1, 11.5


Operating system(s):
AIX, HP-UX, Linux, Mac OS X, Solaris, Windows


Reference #:
1458882


Modified date:
2012-10-26

Translate my page

Content navigation