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.
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.