SET DECIMAL SEPARATOR |  |
Learn more about Verizon Connect GeoBase.
Get information about the latest release
SET DECIMAL SEPARATOR StatementWhen working with input files that use different regional settings to format numeric values, you must indicate what the decimal separator is when it differs from the current system settings. The SET DECIMAL SEPARATOR statement overrides the current decimal separator used to parse numeric values.
If necessary, this statement can be used multiple times in one script. Each time it is used, the new decimal separator is used for parsing numeric values until it is overruled by another SET DECIMAL SEPARATOR statement.
Syntax
SET DECIMAL SEPARATOR separator;
Nomenclature
| separator | The character that separates integral digits from decimal digits. |
Example
SET DECIMAL SEPARATOR ".";
The allegheny sample has a decimal column in the dbf file that uses '.' as a decimal separator. Using this statement allows the file to be used correctly even on a system where the decimal separator is ','.