15.00 - Executing the Teradata PT APPLY Statement - Parallel Transporter

Teradata Parallel Transporter Operator Programmer Guide

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

Executing the Teradata PT APPLY Statement

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;

Following is the Teradata PT processing that occurs in response to this command:

 

Table 8: 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.