ltl_character_case

Specifies the case used for database object names in the LTL sent to the primary Replication Server.

Default

asis

Values

asis – Passes database object names in the LTL output in the same case as they are returned from the primary database, or (if the value of the use_rssd parameter is true) in the case they are specified in replication definitions.

lower – Passes all object names in the LTL output in lower case, regardless of how they are returned from the primary database or specified in replication definitions.

upper – Passes all object names in the LTL output in upper case, regardless of how they are returned from the primary database or specified in replication definitions.

Comments

The ltl_character_case configuration parameter allows you to customize the handling of database object names in the LTL output to work with existing replication definitions that specify the object names differently than the way the primary database returns them.
If the value of the use_rssd parameter is false and the value of the ltl_character_case parameter is asis, database object names are passed in the LTL output in the same case as they are returned from the primary database.
If the value of the use_rssd parameter is true and the value of the ltl_character_case parameter is asis, database object names are passed in the LTL output in the same case as they are specified in the replication definitions (stored in the RSSD of the primary Replication Server).
If object names are specified as all lower case in replication definitions, set the value of the ltl_character_case parameter to lower.
If object names are specified as all upper case in replication definitions, set the value of the ltl_character_case parameter to upper.
If you want to pass database object names with mixed case (for example, TableName), then you must set the value of the ltl_character_case parameter to asis.