IBM Support

IBM InfoSphere DataStage: NLS_LANG settings for Oracle

Troubleshooting


Problem

The following error occurs when accessing Oracle via the Oracle Connector or Enterprise Stage, and the NLS_LANG environment variable is not properly set: The NLS character map is specified, but NLS_LANG is not set; the NLS character map must be set to an ICU codepage which is equivalent to the character set specified by NLS_LANG.

Symptom

Error:
The NLS character map is specified, but NLS_LANG is not set; the NLS
character map must be set to an ICU codepage which is equivalent to
the character set specified by NLS_LANG.

[{"Product":{"code":"SSVSEF","label":"IBM InfoSphere DataStage"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"--","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"8.5;8.1;8.0.1;7.5","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

Modified date:
25 April 2025

UID

swg21439982