Defines the maximum number of decimal digits in the default maximum value used in expression typing.
Field Group
General
Default
15 decimal digits
Changes Take Effect
After the next database restart.
After you perform a system initialization (sysinit) that re-initializes DBS Control, MaxDecimal is set to zero.
Usage Notes
| This MaxDecimal value… | Sets a default DECIMAL maximum size for expression evaluation to… |
|---|---|
| 0 | 15. |
| 15 | 15. |
| 18 | 18. |
| 38 | 38. |
For more information on the DECIMAL data type, see Teradata Vantage™ - Data Types and Literals, B035-1143.