Sybase client configuration

The standard installation of the Sybase Database Server automatically installs the Sybase open clinet, which the operators use to communicate with the Sybase database.

InfoSphere® DataStage® communicates with the Sybase database using the CT library. To support this:

  • Set your SYBASE_OCS Environment variable to the name of the Open Client Directory in the Client Installation. This can be obtained from the server login environment. (For example, for Sybase 12.5 it is OCS-12_5).
  • Set your SYBASE environment variable to your Sybase installation directory.
  • If the database is Sybase ASE, set your SYBASE_ASE environment variable (for example, for ASE 12.5 server it is ASE-12_5). If the database is Sybase IQ server, set your ASDIR environment variable (for example, for IQ 12.5 server it is ASIQ-12_5)
  • Set up the Interface file, adding the details about the database server (database name, host machine name or IP address and port number)
  • Add SYBASE/bin to your PATH and &SYBASE/$ SYBASE_OCS/lib to your LIBPATH, LD_LIBRARY_PATH, or SHLIB_PATH.
  • Have login privileges to Sybase using a valid Sybase user name and a corresponding password. These must be recognized by Sybase before you attempt to access it.
    Note: $SYBASE/$SYBASE_OCS/bin must appear first in your PATH. This is to ensure that $SYBASE/$SYBASE_OCS/bin/isql being executed always, when user executes "isql" command.