Executing the Teradata PT APPLY Statement - 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 Teradata PT APPLY statement to provide the Load operator with selected and filtered data rows:

APPLY
		( <DML statement(s)> )
	TO OPERATOR (LOAD_OPER)
	VIA OPERATOR (MYFILTER)
	SELECT * FROM SEQTAB;

The following table shows the Teradata PT processing that occurs in response to this command:

Processing the Apply Statement 
Function Process
Initiate Sequential producer operator: Open the sequential file.

Filter operator: No operation.

Load consumer operator:
  1. Create logical sessions to communicate with the Teradata Database.
  2. Allocate resources and set up the processing environment.
Execute Sequential producer operator: Read the next row.

Filter Operator: Perform the filter processing.

Load consumer operator: Get the qualified row from the data stream and send it to the Teradata Database.

Terminate Sequential producer operator: Close the sequential file.

Filter operator: No operation.

Load consumer operator:
  • Deallocate resources and terminate the processing environment.
  • Destroy logical sessions.

For more information about the APPLY statement, see the “APPLY” topic in Chapter 3 of the Teradata Parallel Transporter Reference (B035-2436).