Distribution Database datatypes

ASE Replicator creates six user-defined datatypes in the Distribution Database. These datatypes are used by Distribution Database procedures and in Distribution Database tables.

Table A-1 lists the Distribution Database user-defined datatypes, along with their underlying standard Adaptive Server datatypes, and a brief description.

Table A-1: Distribution Database datatypes

Distribution Database datatype

Adaptive Server datatype

Description

rpl_sysname

sysname

Allows sysname to be used in tables

rpl_boolean

bit

Provides a generic Boolean datatype

rpl_blob

bit

Indicates image column value change

rpl_clob

bit

Indicates text column value change

rpl_uclob

bit

Indicates unitext column value change

rpl_java

bit

Indicates java column value change

The rpl_blob, rpl_clob, rpl_uclob, and rpl_java datatypes are used in shadow tables as Boolean datatypes.