Specify values for the scale parameter

You can define a MONEY column with a syntax.

Define a MONEY column with the following syntax.

1  %Data type(1)  MONEY?  ( 
2.1 precision
2.1! 16
2.1  , scale
2.1! 2 )
Notes:
  • 1 See HCL OneDB™ Guide to SQL: Syntax.
Element
Description
precision
Total number of significant digits in a decimal or money data type

You must specify an integer 1 - 32, inclusive. The default precision is 16.

scale
Number of digits to the right of the decimal point.

The scale must be an integer between 1 and precision. If you omit the scale, the database server provides a default scale that the database locale defines. For the default locale (U.S. English), the default is 2, as the diagram indicates.

Internally, the database server stores MONEY values as DECIMAL values. The precision parameter defines the total number of significant digits, and the scale parameter defines the total number of digits to the right of the decimal separator. For example, if you define a column as MONEY(8,3), the column can contain a maximum of eight digits, and three of these digits are to the right of the decimal separator. An example of a data value in the column might be 12345.678.

If you omit the scale parameter from the declaration of a MONEY column, the database server provides a scale that the locale defines. For the default locale (U.S. English), the database server uses a default scale of 2. It stores the data type MONEY(precision) in the same internal format as the data type DECIMAL(precision,2). For example, if you define a column as MONEY(10), the database server creates a column with the same format as the data type DECIMAL(10,2). A data value in the column might be 12345678.90.

For nondefault locales, if you omit the scale when you declare a MONEY column, the database server declares a column with the same internal format as DECIMAL data types with a locale-specific default scale. For example, if you define a column as MONEY(10), and the locale defines the default scale as 4, the database server stores the data type of the column in the same format as DECIMAL(10,4). A data value in the column might be 123456.7890.

The GLS code sets for most European languages can support the euro symbol in monetary values. For the complete syntax of the MONEY data type, see the HCL OneDB Guide to SQL: Syntax. For a complete description of the MONEY data type, see the HCL OneDB Guide to SQL: Reference.