Environment Variables

Sybase IQ uses environment variables to store various types of information; not all variables need to be set in all circumstances.

• Setting Environment Variables on Windows
  On Windows platforms, the installation program automatically sets all environmental variables, so no changes are necessary. However, if you must set optional variables or change defaults, use this procedure.
• Running UNIX Environment Source Files
  Environment source files set the required environment variables on UNIX.
• Setting Environment Variables on UNIX
  On UNIX platforms, running environment source files sets the required environment variables. However, if you must set optional variables or change defaults, use this procedure.
• IQDIR15 Environment Variable
  IQDIR15 identifies the location of the Sybase IQ directory and is the location for other directories and files under that directory.
• IQPORT Environment Variable
  IQPORT overrides the default value for the Sybase IQ Agent port number, which is used for communications between the Sybase IQ plug-in and Agent.
• IQLANG Environment Variable
  IQLANG sets the default language.
• IQLOGDIR15 Environment Variable
  The IQLOGDIR15 environment variable defines the location of various log files. IQLOGDIR15 is not set by the installation program.
• IQTIMEOUT Environment Variable
  IQTIMEOUT overrides the default wait time of five minutes.
• IQTMP15 Environment Variable
  The IQTMP15 environment variable is not set by the installation program. IQTMP15 is used by Sybase IQ to indicate a directory where temporary files are kept.
• JAVA_HOME Environment Variable
  Defines the JRE home which points to directory containing bin/java.
• LIBPATH or LD_LIBRARY_PATH Environment Variable
  LIBPATH or LD_LIBRARY_PATH specifies the directories where Sybase IQ shared libraries are located.
• PATH Environment Variable
  PATH is an operating system required variable that includes the directories where Sybase IQ executables are located.
• SACHARSET Environment Variable
  SACHARSET sets the default character set.
• SQLCONNECT Environment Variable
  SQLCONNECT specifies connection parameters that are used by several of the database administration utilities, such as Interactive SQL, dbinfo, and dbstop, when connecting to a database server.
• SYBASE Environment Variable
  SYBASE identifies the location of Sybase applications, such as Open Client and Open Server.
• $SYBASE_JRE6_32, $SYBASE_JRE6_64, $SYBASE_JRE5_64 Environment Variables
  This variable specifies the location of the Java Runtime Environment used by the Sybase Central plug-in for Sybase IQ.
• SYBASE_OCS Environment Variable
  SYBASE_OCS specifies the home directory for the Open Client product.