Decimal Separator

The Decimal Separator VLDB property specifies whether a "." or "," is used as a decimal separator. This property is used for non-English databases that use commas as the decimal separator.

"." as the decimal separator (default)

select a11.DEPARTMENT_NBR DEPARTMENT_NBR,

 a11.STORE_NBR STORE_NBR

into #ZZTIS00H5K4MQ000

from HARI_COST_STORE_DEP a11

group by a11.DEPARTMENT_NBR,

 a11.STORE_NBR

having sum(a11.COST_AMT) > 654.357

"," as the decimal separator

select a11.DEPARTMENT_NBR DEPARTMENT_NBR,

 a11.STORE_NBR STORE_NBR

into #ZZTIS00H5K5MQ000

from HARI_COST_STORE_DEP a11

group by a11.DEPARTMENT_NBR,

 a11.STORE_NBR

having sum(a11.COST_AMT) > 654,357