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 database. |
| Terminate | Sequential producer operator: Close the sequential file. Filter operator: No operation. Load consumer operator:
|
For more information about the APPLY statement, see Teradata® Parallel Transporter Reference, B035-2436.