Column

 

Data type

 

Description

 

 

 

 

 

 

 

 

 

 

option_id

 

INTEGER

 

An identification number for the

 

 

 

 

 

 

message link parameter.

 

user_id

 

INTEGER

 

The user ID for which the parameter

 

 

 

 

 

 

is set.

 

"setting00"

 

VAR-

 

The value of the message link pa-

 

 

 

CHAR(255)

 

rameter.

sr_remoteoptiontype table

 

 

 

 

 

 

 

Function

Each row describes one of the SQL Remote message link parameters.

Columns

 

 

 

 

 

 

 

 

 

Column

 

Data type

 

Description

 

 

 

 

 

 

 

 

 

 

 

 

 

option_id

 

INTEGER

 

An identification number for the

 

 

 

 

 

 

message link parameter.

 

type_id

 

INTEGER

 

An identification number for the

 

 

 

 

 

 

message type that uses this parameter

 

"option"

 

VAR-

 

The name of the message link pa-

 

 

 

CHAR(128)

 

rameter.

sr_remotetable table

 

 

 

 

 

 

 

Function

Each row describes a table that is marked for replication using SQL Remote.

Columns

 

 

 

 

 

 

 

 

 

Column

 

Data type

 

 

Description

 

 

 

 

 

 

 

 

 

 

 

 

 

table_id

 

INT

 

 

The id of the table.

 

resolve_name

 

VAR-

 

 

The name of the stored procedure to

 

 

 

CHAR(128)

 

 

be executed in the case of conflicts.

 

old_row_name

 

VAR-

 

 

The table that holds the old row

 

 

 

CHAR(128)

 

 

name.

 

remote_row_-

 

VAR-

 

 

The table that holds the remote row

 

name

 

CHAR(128)

 

 

name.

sr_remotetype table

 

 

 

 

 

 

 

Function

Each row describes one of the SQL Remote message types, including the

342

Page 360
Image 360
Sybase DC38133-01-0902-01 manual Srremoteoptiontype table, Srremotetable table, Srremotetype table, 342