Setting environment variables

Required environment variables are set by environment source files on UNIX and by the Sybase IQ installation on Windows.

Issue the following command to set all required environment variables.

1. For the Bourne/Korn shell:

   . $SYBASE/ASIQ-12_6/ASIQ-12_6.sh
   

2. For the C shell:

   source $SYBASE/ASIQ-12_6/ASIQ-12_6.csh;
   rehash
   

On Windows platforms, all environmental variables are set by the install, so no changes should be necessary. However, if you do need to set optional variables or change defaults, use one of the following procedures, as appropriate for your operating system.

1. Right-click on the My Computer icon and select Properties from the popup menu.

2. Click the Advanced tab.

3. Click the Environment Variables button. The Environment Variables dialog opens. If the environment variable does not already exist, click New and type the variable name and its value in the spaces provided, then click OK.

   If the variable does exist, select it from the list of System Variables or User Variables, click Edit, and make any modifications in the Variable Value field. (See the Microsoft Windows documentation for an explanation of user variables and system variables.) Click OK to make the setting.

1. To check the setting for an environment variable, use the following command:

   echo $variable-name
   

   For example, to see the setting for the $SYBASE variable:

   % echo $SYBASE
   

   /server1/users/janed/sybase
   

2. In one of your startup files (.cshrc, .shrc, .login), add a line that sets the variable.

   In some shells (such as sh, bash, ksh) the line is as follows:

    VARIABLE=value;export VARIABLE
   

   In other shells (such as csh, tsch) the line is as follows:

   setenv VARIABLE value
   

The following environment variables used by Sybase IQ are described in this section:

• ASCHARSET

• ASDIR

• ASIQPORT

• ASJRE

• ASLANG

• ASLOGDIR

• ASTMP

• LIBRARY PATH

• PATH

• SQLCONNECT

• SYBASE

• SYBASE_JRE

• SYBASE_OCS