Contents Index BELL option [ISQL] BLOCKING option [database]

ASA Database Administration Guide
  Database Options
    Alphabetical list of options

BLOB_THRESHOLD option [replication]


Function 

Controls the size of value that the Message Agent treats as a long object (blob).

Allowed values 

Integer, in kilobytes

Default 

256

Description 

Any value longer than the BLOB_THRESHOLD option is replicated as a blob. That is, it is broken into pieces and replicated in chunks, before being reconstituted using a SQL variable and concatenating the pieces at the recipient site.

If you set BLOB_THRESHOLD to a high value in remote Adaptive Server Anywhere databases, blobs are not broken into pieces, and operations can be applied to Adaptive Server Enterprise by the Message Agent. Each SQL statement must fit within a message, so this only allows replication of small blobs.


Contents Index BELL option [ISQL] BLOCKING option [database]