Mark Identifiers as Quoted

Use the create replication definition or alter replication definition commands with the quoted parameter to mark identifiers as quoted identifiers.

When dsi_quoted_identifier is on for a replicate server connection and when dsi_quoted_identifier is subscribed to a replication definition that has identifiers marked as quoted identifiers, the marked identifiers are enclosed in double quotes.

When you set dsi_quoted_identifier to on and mark an identifier, the replicate database that subscribes to the replication definition receives the marked identifier as a quoted identifier. If dsi_quoted_identifier is off, the markings are ignored and the identifier sent to the replicate database is not enclosed in double quotes.

Note: When replicating to a warm standby database and to replication definition subscribers, and the primary table name is marked as quoted but the replicate table name is not, or vice-versa, Replication Server sends both the primary table name and the replicate table name as quoted.

Example 1

To create the authors_repdef table replication definition for the authors table with the authors_col_1 column as a quoted identifier:

create replication definition authors_repdef
   with primary at primaryDS.primaryDB
   with all tables named "authors"
   ("authors_col_1" int quoted, "authors_col_2" int)
   primary key ("authors_col1")

Example 2

To mark as quoted the authors table:

alter replication definition authors_repdef
with replicate table named "authors" quoted

Example 3

To unmark the column authors_col_1:

alter replication definition repdef
with replicate table named "authors"
alter columns with "authors_col_1" not quoted

See create replication definition and alter replication definition in the Replication Server Reference Manual .