15.00 - Designing a Filter Operator - Parallel Transporter

Teradata Parallel Transporter Operator Programmer Guide

prodname
Parallel Transporter
vrm_release
15.00
category
Programming Reference
featnum
B035-2435-034K

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.