TD_ConvertTo

fastpath function to cast/convert columns from one datatype to another.

Options

Accumulate: Specifies the input table columns to copy to the output table. By default, the function copies all input table columns to the output table.
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 which needs to be casted/converted to another datattype
TargetDataType (strings seperated by new line): Specify target datatype(s) into which target columns need to be converted. If one value is provided, it applies to all target columns. If more than one value is specified, each TargetDataType value applies to corresponding TargetColumns value (in the order specified by the user).
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.