Additional Settings

Learn about the additional settings provided to support replication.

The settings include:

Settings in ECDA (required)
Use the following settings in the ECDA configuration file:
```
Transaction Mode = long
allocate = connect
```
```
SQL transformation = Sybase
```
Settings for Dynamic SQL (optional)
Dynamic SQL is supported as of Replication Server 15.0.1 and requires DirectConnect UDB 12.6.1 ESD #2, or later.
Settings for Command Batching (optional)
Command batching allows Replication Server to send multiple commands to the data server as a single command batch. You can put multiple commands in a language function-string output template, separating them with semicolons (;). If the database is configured to allow command batches, which is the default, Replication Server replaces the semicolons with that connection’s DSI command separator character before sending the function string in a single batch to the data server. The separator character is defined in the dsi_cmd_separator option of the alter connection command.

If the connection to the database is not configured to allow batches, Replication Server sends the commands in the function string to the data server one at a time. To enable or disable batching for a database, use the alter connection command.
To use command batching, enter:
```
set batch = on 
```
```
set dsi_cmd_separator = ; 
```
```
set batch_begin = off
```
```
use_batch_markers = on
```
For information on setting batch and dsi_cmd_separator options, see the Replication Server Reference Manual > alter connection.