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

Add comments

Document information


More support for:

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

Machine Translation

Content navigation