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 set to "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 when an identifier is marked, the replicate servers that subscribed to the replication definition receive the marked identifier as a quoted identifier. If dsi_quoted_identifier is “off,” the markings are ignored and the identifier sent to the replicate server is not enclosed in double quotes.

To create a table foo with column foo_col1 as a quoted identifier:

create replication definition repdef
   with primary at primaryDS.primaryDB
   with all tables named “foo”
   (“foo_col1” int quoted, “foo_col2” int)
   primary key (“foo_col1”)

To mark as quoted the table named foo:

alter replication definition repdef
   alter replicate table name “foo” quoted

To unmark the column foo_col1:

alter replication definition repdef
   with replicate table name “foo”
   alter columns “foo_col1” not quoted

See Replication Server Reference Manual > Replication Server Commands for the full command syntax of create replication definition and alter replication definition.

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.