Customize currency display formats
The GLS locales contain display formats, which you do not usually need to change. You can set the DBMONEY environment variable, however, to customize the appearance of the currency notation.
A monetary display format string specifies a format for the manipulation
of internal DECIMAL, FLOAT, and MONEY values as monetary literal strings. HCL OneDB™ products
use the following precedence to determine the custom display format
for a MONEY value:
- DBMONEY
- Information that the client locale defines.
CLIENT_LOCALE identifies the client locale; if it is not set, the client locale is the default locale.
- Default currency notation = $,.
If DBMONEY is not set, and no locale is specified, the currency symbol is the dollar sign, the thousands separator is the comma, and the decimal separator is the period.