Max Digits in Constant

Max Digits in Constant is an advanced property that is hidden by default. For information on how to display this property, see Viewing and Changing Advanced VLDB Properties.

The Max Digits in Constant property controls the number of significant digits that get inserted into columns during Analytical Engine inserts. This is only applicable to real numbers and not to integers.

Levels at Which You Can Set This

Database instance only

Database-specific setting

SQL Server	28
Teradata	18

Max Const Digits = 0

Insert into #ZZTIS00H6WQMD001 values (4, 339515.0792)

Max Const Digits = 2

Insert into #ZZTIS00H6WTMD001 values (4, 33)

Max Const Digits = 7

Insert into #ZZTIS00H6WVMD001 values (4, 339515.0)