17.00 - Executing the Teradata PT APPLY Statement - Parallel Transporter

Teradata® Parallel Transporter Operator Programmer Guide

prodname
Parallel Transporter
vrm_release
17.00
created_date
June 2020
category
Programming Reference
featnum
B035-2435-220K

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 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 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 Teradata® Parallel Transporter Reference, B035-2436.