Enhanced text Update

Replication Server supports the replication of large objects such as text and image to non-ASE servers by passing a writetext command to DirectConnect Anywhere™, where it is converted to an update statement.

The writetext command includes large-object pointers that an update statement uses to search and propagate the replicate database. Most data servers have their own unique implementation of updating large objects. Therefore, large-object replication to these servers becomes slow and inefficient, often requiring a full table scan of the replicate database for a single update.

Replication Server 15.1 provides an option to include primary keys with writetext commands sent to DirectConnect Anywhere. With the primary keys, DirectConnect Anywhere can create update statements that can efficiently search and replicate the replicate database.

Replication Server 15.1 introduces the Data Server Interface (DSI) configuration parameter dsi_alt_writetext. Use dsi_alt_writetext to instruct the Replication Server to include a text pointer or a set of primary keys with the writetext command.

Note: You need ECDA 15.0 ESD #2 to use this feature.

For more information, see the Replication Server Reference Manual.