#START JOB MON APP DATASTAGE HOW TO#

The three arguments of NLS_LANG can be specified in many combinations, as in the following examples: If you specify territory or charset, you must include the preceding delimiter, otherwise the value will be parsed as a language name. Note: All components of the NLS_LANG definition are optional any item left out will default. For a complete list of character sets, see 'Character Sets'. Default values for the languages available on your system are listed in the installation or user's guide. Each language has a default character set associated with it. Each supported character set has a unique acronym, for example, US7ASCII, WE8ISO8859P1, WE8DEC, WE8EBCDIC500, or JA16EUC. Specifies the character set used by the client application (normally that of the user's terminal). For a complete list of territories, see 'Territories'. If territory is not specified, the value defaults to America. Each supported territory has a unique name for example, America, France, or Canada. Specifies conventions such as the default calendar, collation, date, monetary, and numeric formats. For a complete list of languages, see 'Languages'. If language is not specified, the value defaults to American. The language argument specifies default values for the territory and character set arguments, so either (or both) territory or charset can be omitted. Each supported language has a unique name for example, American, French, or German. Specifies conventions such as the language used for Oracle messages, day names, and month names. The NLS_LANG parameter has three components ( language, territory, and charset) in the form:Д®ach component controls the operation of a subset of NLS features. Using this one parameter ensures that the language and territory environment for both the server and client are the same.

It sets the language, territory, and character set used by the database for both the server session and the client application. Setting the NLS_LANG parameter is the simplest way to specify locale behavior.

Table 2-2 Parameters and their Scope ParameterДЄ locale is a linguistic and cultural environment in which a system or program is running. Table 2-2 lists the NLS parameters available with the Oracle server. Specified in the initialization parameter file Table 2-1 Parameters and Their Priorities And explicitly setting an NLS parameter within a SQL function can override all other settings - default, INIT.ORA, environment variable, and ALTER SESSION parameters. For example, a default value will have the lowest possible priority, and can be overridden by any other method. Higher priority settings will override lower priority settings. Table 2-1 shows the precedence order when using NLS parameters. TO_CHAR(hiredate, 'DD/MON/YYYY', 'nls_date_language = FRENCH') Doing so will override the defaults set for the server in the initialization file, the client with environment variables, or ALTER SESSION on the client. NLS parameters can be used explicitly to hardcode NLS behavior within a SQL function. SVRMGR> ALTER SESSION SET NLS_SORT = FRENCHДЇor a complete description of ALTER SESSION, see Oracle8i SQL Reference.

NLS parameters set in an ALTER SESSION statement can be used to override the defaults set for the server in the initialization file, or set by the client with environment variables. NLS parameters can be used to specify locale-dependent behavior for the client, overriding the defaults set for the server in the initialization file.

As environment variables on the client.

These settings have no effect on the client side they control only the server's behavior. Parameters can be included in the initialization file (INIT.ORA) to specify a default server NLS environment.

As initialization parameters on the server.

There are four ways to specify NLS parameters: NLS parameters determine the locale-specific behavior on both the client and the server.

#START JOB MON APP DATASTAGE HOW TO#

This chapter tells how to set up an NLS environment, and includes the following topics:

Start job mon app datastage