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:
  1. DBMONEY
  2. Information that the client locale defines.

    CLIENT_LOCALE identifies the client locale; if it is not set, the client locale is the default locale.

  3. 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.