Error checking during data transfer

The IFX_LOB_XFERSIZE environment variable is used to specify the number of kilobytes in a CLOB or BLOB to transfer from a client application to the database server before checking whether an error has occurred.

The error check occurs each time the specified number of kilobytes is transferred. If an error occurs, the remaining data is not sent and an error is reported. If no error occurs, the file transfer continues until it finishes.

The valid range for IFX_LOB_XFERSIZE is from 1 to 9223372036854775808 kilobytes. The IFX_LOB_XFERSIZE environment variable is set on the client.

For more information about IFX_LOB_XFERSIZE, see the HCL OneDB™ Guide to SQL: Reference.