BULKLOADING Subcommand (SAVE TRANSLATE command)

The BULKLOADING subcommand controls settings for bulk loading to a database. Bulk loading can make the export much faster, particularly for large data files.

METHOD=OFF | BATCH | ODBC

Specifies the bulk loading method.

• OFF. Bulk loading is turned off. Records are committed to the database one at a time. This option is the default setting.
• BATCH. Commits records to the database in the batch size value that is specified for the BATCHSIZE keyword.
• ODBC. Uses the ODBC binding method to commit records in the specified batch size. This option is available only if the database supports ODBC binding. This option is not available on Mac OS.

BATCHSIZE=integer

Specifies the batch size. The value must be a positive integer. The default value is 10000.

BINDING=ROW | COLUMN

For ODBC binding, specifies row or column binding. This setting is ignored unless METHOD=ODBC.

• ROW. Row-wise binding typically improves speed compared to the use of parameterized inserts that insert data on a record-by-record basis. This option is the default setting.
• COLUMN. Column-wise binding improves performance by binding each database column to an array of n values.