Components for Non-ASE Support Installed with Replication Server

The components included in the Replication Server default installation are connection profiles that contain function-string classes and error classes for each actively supported database, datatypes class, Replication Server native datatype literal descriptor row in the RSSD rs_datatype table, and Replication Server datatype translation engine.

Replication Server includes connection profiles that you use to connect to non- ASE data servers. Connection profiles contain or install these components:

Datatype definitions – assign a unique datatype ID to each datatype, and describe the attributes of each non-ASE datatype, such as delimiters, length, scale, precision, minimum and maximum values, how it is represented using native Replication Server datatypes. Replication Server uses datatype definitions to:
- Identify datatypes
- Convert datatypes into native datatypes for internal handling (if necessary)
- Translate datatypes
Replication Server support objects in the replicate database – Replication Server relies on a replicate database to maintain some of the operational data that Replication Server needs to replicate to that database.
Non-ASE support accommodates the Replication Server replicate database requirements by creating two tables in the replicate database:
- rs_info – stores the character set and sort order used by the database. The Replication Server maintenance user ID must have select permission on this table.
- rs_lastcommit – is used by the replicate Replication Server to record information about the most recent replicated operations committed in the replicate database. Because this table is both read and updated by the replicate Replication Server, the Replication Server maintenance user ID must have both insert and update permission on this table.
Replication Server function strings – allow users to customize the database operations sent by the replicate Replication Server to the replicate database. Non-ASE support uses function strings to replace invocations of stored procedures and certain database commands that the replicate Replication Server sends to the replicate database.
The function strings required to support connections to non-ASE data servers are installed in the RSSD of the replicate Replication Server.

For functions-string classes, see Replication Server Administration Guide Volume 2 > Customizing Database Operations and for datatype classes, see Replication Server Reference Manual > Topics.
Class-level translations for non-ASE datatypes – default datatype-to-datatype mappings, provided by connection profiles.
Connection profiles provide a function-string class for each supported database server. The class-level translations are specific to each function-string class that supports a non-Sybase replicate database.