Load Operator as Standalone Operator
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
Note: 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]);
);
Note: Use LOAD as a standalone operator to apply data on the target table without sending more data.