Optional Syntax Elements for TD_RoundColumns

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.

Optional Syntax Elements for TD_RoundColumns - Teradata VantageCloud Lake