Designing a Filter Operator - Parallel Transporter

Teradata Parallel Transporter Operator Programmer Guide

Product
Parallel Transporter
Release Number
16.10
Published
May 2017
Language
English (United States)
Last Update
2018-05-07
dita:mapPath
tig1488824663180.ditamap
dita:ditavalPath
Audience_PDF_include.ditaval
dita:id
B035-2435
lifecycle
previous
Product Category
Teradata Tools and Utilities

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

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. Do the following for each of the column handles involved in the filter task:
    1. Use the Get Column Value function to get the column value.
    2. 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.

Example - 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.