rs_datatype

Stores attribute information for all user-defined datatypes (UDDs) in a replication definition.

Column

Datatype

Description

prsid

int

Can be:

  • ID of primary Replication Server

  • 0 for globally defined UDDs

classid

rs_id

ID of datatype class to which the datatype belongs

dtname

varchar(30)

Unique name of datatype

dtid

rs_id

Unique ID of datatype

base_coltype

tinyint

ID of base datatype for the datatype. Can be:

  • 0 – char

  • 1 – binary

  • 2 – longchar (not used)

  • 3 – longbinary (not used)

  • 4 – text

  • 5 – image

  • 6 – tinyint

  • 7 – smallint

  • 8 – int

  • 9 – real

  • 10 – float

  • 11 – bit

  • 12 – datetime

  • 13 – smalldatetime

  • 14 – money

  • 15 – smallmoney

  • 16 – numeric

  • 17 – decimal

  • 18 – varchar

  • 19 – varbinary

  • 21 – sensitivity

  • 25 – unichar

  • 27 – date

  • 28 – time

  • 29 – unitext

   
  • 30 – bigint

  • 31 – usmallint

  • 32 – uint

  • 33 – ubigint

  • 35 – bigdatetime

  • 36 – bigtime

  • 101 – numeric (literal)

  • 102 – money (literal)

  • 103 – real (literal)

  • 104 – float (literal)

  • 105 – identity (literal)

  • 106 – timestamp (literal)

  • 107 – sensitivity (literal)

  • 110 – univarchar

length

int

Maximum length of a value of the datatype. For UDDs with masks defined as decimal or money, the value is the maximum precision plus four.

status

int

Status. (See the status column in the rs_columns table.)

length_err_act

tinyint

Action to be taken if value exceeds length identified in length. Can be:

  • 1 – error

  • 2 – continue

  • 3 – truncate left

  • 4 – truncate right

  • 5 – round up

  • 6 – round up and continue on error

  • 7 – round up and use default on error

  • 8 – round up and use minimum on error

  • 9 – round up and use maximum on error

  • 10 – round down

  • 11 – round down and continue on error

  • 12 – round down and use default on error

  • 13 – round down and use minimum on error

  • 14 – round down and use maximum on error

mask

varchar(255)

Datatype mask. Datatype must have base datatype of char for non-null mask.

scale

int

Maximum number of digits to the right of decimal point. Valid only for masks of money or decimal.

default_len

tinyint

Length of value in

default_val

column.

default_val

binary(255)

Default value. Supplies missing components for target value during translation to this datatypes.

delim_pre_len

tinyint

Length of delim_pre value.

delim_pre

binary(30)

Postfixing character or character string used when mapping a non-Java value into a function string. An empty string if the delimiter prefix for the base datatype is used.

delim_post_len

tinyint

Length of delim_post.

delim_post

binary(30)

Postfixing character or character string used when mapping a non-Java value into a function string. An empty string if the delimiter prefix for the base datatype is used.

min_boundary_ len

tinyint

Length of value in min_boundary column.

  • 1 – error

  • 2 – use default

  • 3 – use minimum

  • 4 – use maximum

min_boundary

binary(255)

Minimum acceptable value for datatype.

min_boundary_ err_act

tinyint

Action to be taken if the value exceeds the minimum boundary set by min_boundary. Can be:

  • 1 – error

  • 2 – use default

  • 3 – use minimum

  • 4 – use maximum

max_boundary_ len

tinyint

Length of value in max_boundary.

max_boundary

binary(255)

Maximum acceptable value for datatype.

maximum_ boundary_err_act

tinyint

Action to be taken if a value exceeds the maximum boundary set by max_boundary. Can be:

  • 1 – error

  • 2 – use default

  • 3 – use minimum

  • 4 – use maximum

rowtype

tinyint

Indicates whether a row is local to Replication Server or distributed to all Replication Servers in the domain. Can be:

  • 0 – local

  • 1 – global

canonic_type

tinyint

DSI uses the value of canonic_type to convert the UDD to the correct data type when sending dynamic SQL execute commands. A value of 255 indicates that this datatype is incompatible with dynamic SQL.

Indexes

  • Unique index on (dtid)

  • Unique index on (name)

  • Non-unique index on (classid)

  • Non-unique index on (prsid)