Server setting problem

Ultramundane · Post by **Ultramundane** » Tue Oct 10, 2006 12:03 pm

I am not aware of any significant settings that can be set for sort. You can set the temporary directory at the command line. I believe that sort will pick up whatever locale is currently being used. Maybe your shell is using a different locale than what datastage is using. You can run the command "locale" to determine what locales you are using. Copy the output and put it into your shell script before you call the sort command. Rerun your shell script through datastage and see if it still fails.

Alagusakthivelan · Post by **Alagusakthivelan** » Wed Oct 11, 2006 8:36 am

Hi can you tell me where exactly i have to use the command "locale".

and what it will return? how i can change the datastage "locale".

please help me out in this issue.

ray.wurlod · Post by **ray.wurlod** » Wed Oct 11, 2006 2:13 pm

locale is a UNIX command, so is executed at the UNIX prompt. It merely reports your current O/S locale setting.

In DataStage you can change the locale in the Administrator client by clicking the NLS button.