Using BULKLOAD=YES is
the fastest way to insert rows into a DBMS table.
You can specify additional
options in the BULKOPTS= container option (BL_BULKOPTS= for Oracle).The
additional options require the BULKOPTS= container option. For more
information, see
BULKOPTS= Table Option.
MDS: BULKLOAD=
is available for insert operations only. When the BULKLOAD= table
option is set, newly inserted rows are committed immediately and become
visible to existing transactions. When the BULKLOAD= table option
is not set, newly inserted rows are not visible until the existing
transactions are committed or rolled back.
Teradata: When
the BULKLOAD= table option is not set, a simple multi-row insert SQL
scheme is used to insert data rows. Specifying BULKLOAD=YES invokes
the Teradata Parallel Transporter (TPT) API protocol driver. The default
TPT operator is the Stream operator. Use the BULKOPTS= table option
to specify a different TPT operator.