Appendix A: Distribution Database Schema
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.
|
Copyright © 2005. Sybase Inc. All rights reserved.
|
|
View this book as PDF 