Class-Level Datatype Translations to RSSD

Class-level translations identify primary datatypes and the replicate datatypes the data must be translated into (for example, DB2 UDB TIMESTAMP should be translated to Oracle DATE).

Class-level translation is supplied for the Oracle replicate database by the appropriate named connection profile:

rs_ase_to_oracle – installs Adaptive Server-to-Oracle class-level translations.
rs_db2_to_oracle – translates DB2 UDB for z/OS datatypes to Oracle datatypes.
rs_udb_to_oracle – translates DB2 UDB (for UNIX and Windows) datatypes to Oracle datatypes.
rs_msss_to_oracle – translates Microsoft SQL Server datatypes to Oracle datatypes.

To see all the available profiles, use the admin show_connection_profiles command.

An example of a script using ExpressConnect for Oracle version profile for an Adaptive Server Enterprise (ASE) to Oracle replication environment:

create connection to oracleSID_name.oracleSID_name
using profile rs_ase_to_oracle;eco
set username rs_maint_user
set password rs_maint_user_pwd
go