TD_​GetRowsWithoutMissingValues

fastpath function to get rows without NULL values.

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 in which NULL values needs to be checked. By default all the input table columns are considered as TargetColumns
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_GetRowsWithoutMissingValues

Nodes

Extensions

Links