Designing a Filter Operator - Parallel Transporter

Teradata Parallel Transporter Operator Programmer Guide

Product
Parallel Transporter
Release Number
15.00
Language
English (United States)
Last Update
2018-09-28
dita:id
B035-2435
lifecycle
previous
Product Category
Teradata Tools and Utilities

Designing a Filter Operator

Use the following process guidelines for implementing the Initiate, Execute, and Terminate functions for a filter operator:

 

Table 7: Designing a Filter Operator

Function

Process

Initiate

None.

Execute

1 Use the Get Table Schema List function to get the input data schema handle.

2 Use the Get Row function to read a row.

3 Use the Get Column Schema function to get the column handles associated with the input data schema.

4 For each of the column handles involved in the filter task:

a
Use the Get Column Value function to get the column value.
b
Compare the column value with the filter value.

5 If all column values satisfy the filter criteria, return PXSTC_EndMethod status, otherwise return PXSTC_DiscardRow status.

Terminate

None.

Sample Filter Operator

On Windows, see the following text file in the Teradata Parallel Transporter installation folder for a sample filter operator: TPT_install_directory\sdk\src\samplefilter.cpp.