Quoted Identifiers Without Replication Definition Support

Replication Server can add quotes to all identifiers without checking whether the identifier is quoted in a replication definition or in the primary Adaptive Server database.

Setting the connection-level dsi_quoted_identifier to on enables quoted identifier support for primary tables only created in Adaptive Server 15.7.1 and later.

Setting the connection-level dsi_quoted_identifier to always automatically adds quotes to object names and ensures that replication continues for all primary data servers supported by Replication Server. Otherwise, the DSI connection to the replicate database can shut down and stop replication if Replication Server processes table names that are not quoted and not specified in a table replication definition with the quoted clause. See the Replication Server Release Bulletin for supported Adaptive Server versions and the Replication Server Options Release Bulletin for supported non-Adaptive Server data servers and versions.

We recommend that you to set connection-level dsi_quoted_identifier to always if you are using database replication definition. If there is any object that cannot work the with always value, set table-level dsi_quoted_identifier to an appropriate value for the object.

Example 1

To ensure that replication proceeds even if some table names are not quoted in the corresponding table replication definitions, set the always option for all tables for a new connection to the rdb replicate database in the NY_DS data server. At the replicate Replication Server, enter:

create connection to NY_DS.rdb
...
set dsi_quoted_identifier to always
...
go

Example 2

Ensure that replication proceeds for the authors table owned by Alice, for an existing connection to the rdb replicate database in the LON_DS data where the replication definition for authors might not have set the table name as quoted. At the replicate Replication Server, enter:

alter connection to LON_DS.rdb
for replicate table named alice.authors
set dsi_quoted_identifier to always
go