Configuring the environment for Sybase enterprise stages

About this task

You must install the Sybase open client software on the server side for the Sybase Enterprise Stage to function. The configuration details are below.

Create the user-defined environment variable SYBASE and set this to the $SYBASE path that specifies the Sybase home directory (for example, export SYBASE=/disk3/Sybase).
Create the user-defined environment variable SYBASE_OCS and set this to the Sybase open client software installation directory (for example, export SYBASE_OCS=OCS-12_5).
Interfaces file: Add the details about the database server (database name, host machine name or IP address, and port number) to the interfaces file located in $SYBASE directory.
Add $SYBASE/$SYBASE_OCS/bin to your PATH and $SYBASE/$SYBASE_OCS/lib to your LIBPATH, LD_LIBRARY_PATH, or SHLIB_PATH.
Get login privileges to Sybase by using a valid Sybase user name and corresponding password, server name, and database. 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 is executed whenever the user executes the "isql" command.

The steps for accessing Sybase databases with NLS are as follows:

Procedure

Create a database and configure the language that you wish to test for this database. (For example, create database <<database path>> COLLATION 932JPN for a Japanese (shift_jis) database.
Install the IBM® InfoSphere® DataStage® server in that particular language, for example, Japanese (shift_jis). Upgrading the existing InfoSphere DataStage server will not work as you will not get any option for selecting another language. You must uninstall and reinstall the existing server in the desired language.
Make sure that the language that you want to test is a default setting in the operating system of the machine which you will use to test through the InfoSphere DataStage client. Select the appropriate language by using the Control Panel > Regional Settings option in the Start menu on your desktop. Additionally, you must set the keyboard input to the language that you want to test.

Results

For the InfoSphere DataStage client setting, use the NLS tab in the Sybase Enterprise stage to select the language that you want to test. For example, if Japanese is the default language for your operating system, then the project default in the InfoSphere DataStage client will be Shift_JIS. You do not need to select the language for every job that you run.