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:
Function | Process |
---|---|
Initiate | Sequential producer operator: Open the sequential file. Filter operator: No operation. Load consumer operator:
|
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:
|
For more information about the APPLY statement, see the “APPLY” topic in Chapter 3 of the Teradata Parallel Transporter Reference (B035-2436).