Additional Settings

Learn about the additional settings provided to support replication.

The settings include:

Settings in ECDA
Use the following settings in the ECDA configuration file:
```
Transaction Mode = long
allocate = connect
```
```
SQL transformation = Sybase
```
When set batch is “on,” you must also specify:
```
DelimitSqlRequests = yes
```
If you have a tinyint datatype at the replicate table, the following parameter must be added to the Datatype Conversion section of the Microsoft SQL service in ECDA Microsoft SQL Server.
```
TinyIntResults=tinyint
```
Settings for Dynamic SQL
Dynamic SQL is supported as of Replication Server 15.0.1 and requires ECDA Option for ODBC 12.6.1 ESD #2, or later.
Settings for command batching
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:
```
batch = on
```
```
batch_begin = on or off
```
The use of on for batch_begin reduces the number of network transfers.
```
use_batch_markers = off 
```
Additional batch markers are not required.
When set batch is “on,” you must also specify the following configuration:
```
dsi_cmd_seperator set = ;
```
If you do not specify this configuration, ECDA ignores the commits after each batch , and all the replicate requests are rolled back after the dsi connection fades out.

For information on setting batch and dsi_cmd_separator options, see the Replication Server Reference Manual > alter connection.