BL_OPTIONS= Table Option

Passes options to the DBMS bulk load facility, affecting how it loads and processes data.

Category: Bulk Loading
Requirements: Must follow BULKLOAD=YES
Must be specified within the BULKOPTS= Table Option
Data source: DB2 under UNIX and PC

Syntax

BL_OPTIONS= 'option [, …option ] '

Arguments

option

specifies a valid DB2 option. By default, no options are passed.

Details

The BL_OPTIONS= table option enables you to pass options to the DBMS bulk load facility when it is invoked, thereby affecting how data is loaded and processed. You must separate multiple options with commas and enclose the entire string of options in single quotation marks.
This option passes DB2 file type modifiers to DB2 LOAD or IMPORT commands to affect how data is loaded and processed. Not all DB2 file type modifiers are appropriate for all situations. You can specify one or more DB2 file type modifiers with .IXF files. For a list of file type modifiers, see the description of the LOAD and IMPORT utilities in DB2 Data Movement Utilities Guide and Reference.

Example

This option is specified within the BULKOPTS= table option:
bulkload=yes; bulkopts=(bl_options='option1, option2');