MSCEWI3062

Numeric characters cannot be altered in Snowflake. The decimal separator in snowflake is the dot character.

This is a deprecated version of the SnowConvert documentation, please visit the official site HERE.

Severity

Medium

Description

Numeric characters cannot be altered in snowflake. The decimal separator in snowflake is the dot character. The ALTER session statement is commented and a warning is added.

Example Code

Input Code:

ALTER SESSION SET NLS_NUMERIC_CHARACTERS = ',.';

Output Code:

-- ** MSC-ERROR - MSCEWI3062 - NUMERIC CHARACTERS CANNOT BE ALTERED IN SNOWFLAKE. THE DECIMAL SEPARATOR IN SNOWFLAKE IS THE DOT CHARACTER. **
-- ALTER SESSION SET NLS_NUMERIC_CHARACTERS = ',.'

Recommendations

• No end-user actions are required.

• If you need more support, you can email us at [email protected]