skip to main content
Using the ODBC Client : Specifying ODBC Connection Attributes : BulkBinaryThreshold
 

BulkBinaryThreshold

Attribute

BulkBinaryThreshold (BBT)

Description

The maximum size, in KB, of binary data that is exported to the bulk data file.

Valid Values

-1 | 0 | x
If set to -1, all binary data, regardless of size, is written to the bulk data file, not to an external file.
If set to 0, all binary data, regardless of size, is written to an external file, not the bulk data file. A reference to the external file is written to the bulk data file.
If set to x, any binary data exceeding this specified number of KB is written to an external file, not the bulk data file. A reference to the external file is written to the bulk data file.
See Using DataDirect Bulk Load for more information.

Default

32