DATA_TRANSFER_MODE

You are looking at an older version of the documentation. The latest version is found here.

This option defines the data transfer mode and can be set to one of the following values:

Value	Description
`ITERATOR`	Inserts continuously the whole source and possibly uses [disk] buffers
`BATCH`	Inserts one batch at a time; default batch size is 512 rows
`SINGLE`	Inserts one row a time
`STREAM`	Bufferless data transfer

Default Behaviour

If not explicitly set to one of the values, DATA_TRANSFER_MODE is auto-selected based on the destination database translator capabilities. The auto select mode is the default mode and also can be set via the following command:

CODE

CALL SYSADMIN.setDefaultOptionValue('DATA_TRANSFER_MODE', '')

Usage Per Query

DATA_TRANSFER_MODE can also be used as a single-query option:

CODE

SELECT .... OPTION $DATA_TRANSFER_MODE STREAM