Datatype Definitions

Sybase provides a set of user defined datatypes and datatype classes. You can use them to change the datatype of column values when you replicate between:

  • Sybase data servers

  • Sybase data servers and non-Sybase data servers

  • Homogeneous non-Sybase data servers

  • Heterogeneous non-Sybase data servers

A datatype definition describes a non-Sybase datatype in terms of a base Replication Server native datatype. The base datatype determines the maximum and minimum length associated with the datatype definition and provides defaults for other datatype attributes. The base datatype also defines the delimiters associated with the datatype definition.

Each datatype class contains datatype definitions for a specific data server. The datatype classes are:

  • Adaptive Server – rs_sqlserver_udd_class

  • SQL Anywhere® – rs_asa_udd_class

  • DB2 – rs_db2_udd_class

  • Microsoft SQL Server – rs_msss_udd_class

  • Oracle – rs_oracle_udd_class

For a list and description of supported datatype definitions for each datatype class, see the Replication Server Heterogeneous Replication Guide.

Parent topic: Datatypes