The Replication Agent allows you to control how it sends Oracle DATE column values to the Replication Server. There are two options:
Send the value as a character string (the default).
Send the value as a Sybase datetime value.
The value of the Replication Agent pdb_convert_datetime configuration parameter determines how the Replication Agent handles temporal datatypes.
If you set the pdb_convert_datetime parameter to true, all corresponding datatypes in a replication definition for DATE columns are converted to the Sybase datetime datatype.
If you set the pdb_convert_datetime parameter to false, the datatype in a replication definition for a DATE column must be either:
A Replication Server user-defined datatype (UDD), or
A character datatype.
The character (char or varchar) datatype specified in a replication definition for for a DATE column must have sufficient length to accommodate the column’s default display length.
For a full description of the pdb_convert_datetime parameter and a complete list of datatype mapping for Oracle datatypes, see the Replication Agent Administration Guide. For more information on UDDs and their use, see the Replication Server Administration Guide.
