DECIMAL POINT IS field (DECIMAL DECP value)
The DECIMAL DECP value determines whether the decimal point for numbers is to be a comma (,) or a period (.).
| Acceptable values: | . (period) or , (comma) |
|---|---|
| Default: | . (period) |
| Update: | recommended only to recover an error |
| dsnhdecp: | DECIMAL |
For example, some nations customarily signify the number one
and one-half,
as 1.5; other nations use 1,5 for the same value.
This parameter is used in the following cases:
- For running dynamic SQL statements with DYNAMICRULES:
- Whether the value of field DECIMAL POINT IS is COMMA or PERIOD, Db2 recognizes the value as the decimal point for numbers.
- For binding, defining, or invoking dynamic SQL statements with
DYNAMICRULES:
- If the value of field USE FOR DYNAMICRULES is NO, Db2 does not use the value in field DECIMAL POINT IS if you specify the option COMMA or PERIOD when you precompile the application that contains the dynamic SQL statements. Db2 uses the precompiler option to determine the decimal point for numbers.
- If the value of field USE FOR DYNAMICRULES is YES, and the value of field DECIMAL POINT IS is PERIOD or COMMA, Db2 recognizes the value as the decimal point for numbers.
- For static SQL statements in COBOL programs, DECIMAL POINT IS specifies the default precompiler option (PERIOD or COMMA).
This parameter is the default for binds at this Db2 site that are requested by a remote system that does not indicate whether the period or the comma is used to represent a decimal point. In most cases, however, requesting systems give Db2 this information.