TD_​RoundColumns

fastpath function to round all the TargetColumns upto N decimal places as specified in the argument PrecisionDigit.

Options

Accumulate
Specifies the input table columns to copy to the output table. By default, the function copies no input table columns to the output table.
PrecisionDigit
Specify the N decimal places to which rounding needs to be done for the TargetColumns. IF positive, rounding happens right of the decimal, otherwise left of the decimal. It rounds to 0 decimal places if not provided.
Output Schema
Output Schema, if Volatile is true then use user login as the schema.
Output Table
Output Table
VAL Location
VAL Location
TargetColumns
Specifies the input table columns for which data needs to be round upto N decimal places.
Volatile
Specifies whether the table should be a VOLATILE table. If true, then the table is automatically deleted, otherwise it is users responsibility to remove or clean it up for space.

Input Ports

Icon
Connection to a Teradata Database Instance
Icon
The relation that contains input data.

Output Ports

Icon
output of TD_RoundColumns

Nodes

Extensions

Links