ASA Database Administration Guide
Database Options
Alphabetical list of options
Controls the size of value that the Message Agent treats as a long object (blob).
Integer, in kilobytes
256
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.