Optional Syntax Elements for TD_RoundColumns - Teradata Vantage

Teradata® VantageCloud Lake
Deployment
VantageCloud
Edition
Lake
Product
Teradata Vantage
Published
January 2023
ft:locale
en-US
ft:lastEdition
2024-12-11
dita:mapPath
phg1621910019905.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
phg1621910019905
PrecisionDigit
Specify the number of decimal places to which to round values.
If precision is positive, the function rounds values to the right of the decimal point.
If precision is negative, the function rounds values to the left of the decimal point.
Default: If the PrecisionDigit value is not provided, the function rounds the column values to 0 places.
If the column values have the DECIMAL/NUMERIC data type with a precision less than 38, then the function increases the precision by 1. For example, when a DECIMAL (4,2) value of 99.99 is rounded to 0 places, the function returns a DECIMAL (5,2) value, 100.00. However, if the precision is 38, then the function only reduces the scale value by 1 unless the scale is 0. For example, the function returns a DECIMAL (38, 36) value of 99.999999999 as a DECIMAL (38, 35) value, 100.00.
Accumulate
Specify the names of the InputTable columns to copy to the output table.