Executing the Teradata PT APPLY Statement

Executing the Teradata PT APPLY Statement - Parallel Transporter

Teradata Parallel Transporter Operator Programmer Guide

Product

Parallel Transporter

Release Number

15.00

Language

English (United States)

Last Update

2018-09-28

dita:id

B035-2435

lifecycle

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;

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.