16.10 - Executing the Teradata PT APPLY Statement - Parallel Transporter

Teradata Parallel Transporter Operator Programmer Guide

prodname
Parallel Transporter
vrm_release
16.10
created_date
May 2017
category
Programming Reference
featnum
B035-2435-057K

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