Data server error handling

Replication Server allows user-definable error processing for data server errors. This is accomplished by creating an error class for a database and specifying responses for each error that the data server returns when the error is encountered in the database. The data server returns the defined errors to Replication Server. Table 6-2 lists the RCL commands and Adaptive Server system procedures that manage errors and error classes.

Table 6-2: RCL commands and system procedures for error processing

Command

Description

rs_helpclass

Adaptive Server system procedure that displays the name of each existing error class, function-string class, and their primary Replication Server

create error class

Creates a new error class

drop error class

Drops an existing error class

assign action

Specifies an error processing action for one or more data server errors

create connection

Associates an error class with a new database connection

alter connection

Associates an error class with an existing database connection

A default error class, rs_sqlserver_error_class, is provided for Adaptive Server databases.