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.