In addition to its other capabilities, the Load operator can function as a standalone operator and supports an APPLY statement with no SELECT statement and no INSERT statement. To use LOAD as a standalone operator, use one of the following definitions:
TYPE LOAD STANDALONE TYPE LOAD
The STANDALONE keyword is optional.
In the following example, the STANDALONE keyword is omitted:
DEFINE JOB LOAD_USER_DATA ( DEFINE OPERATOR LOAD_OPERATOR TYPE LOAD ( . . . ); . . . APPLY TO OPERATOR (LOAD_OPERATOR[1]); );
Use LOAD as a standalone operator to apply data on the target table without sending more data.