DATA_TRANSFER_MODE

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