Locale information for the client application

The database server must know how to interpret the display formats when they show in monetary, date, or time data that the client application sends. It must also convert data from the database to any appropriate display before it sends this data to the client application.

For more information about display formats, see Display formats.

The database server uses the following precedence to determine this client-application information:
  1. DBDATE and DBTIME environment variables for the date and time display formats and DBMONEY for the monetary display formats (if one of environment variables is set on the client)

    Support for DBDATE and DBTIME provides compatibility with earlier versions for client applications that are based on earlier versions of HCL® OneDB® products. It is recommended that you use GL_DATE and GL_DATETIME for new applications.

  2. GL_DATE and GL_DATETIME environment variables (if one of environment variables is set on the client) for the date and time display formats
  3. The locale that the CLIENT_LOCALE environment variable from the client application indicates
Tip: The precedence rules apply to how the database server determines the NUMERIC, MONETARY, TIME, and MESSAGES categories of the server-processing locale. For more information about these locale categories, see Locale categories.

The client application passes the DBDATE, DBMONEY, DBTIME, GL_DATE, and GL_DATETIME environment variables (if they are set) to the database server. It also passes the CLIENT_LOCALE and DB_LOCALE environment variables. For more information, see Send the client locale.