alter error class

Changes an existing error class by copying error actions from another error class.

Syntax

alter [replication server] error class error_class
   set template to template_error_class

Parameters

replication server – Indicates that the error class is a Replication Server error class and not a data server error class.
error_class – The error class to modify.
set template to template_error_class – Use this clause to update an error class based on another error class. alter error class copies the error actions from the template error class to the existing error class.

Examples

Example 1 – Changes my_error_class using rs_sqlserver_error_class as the basis:

alter error class my_error_class
    set template to rs_sqlserver_error_class

Example 2 – Changes the my_rs_err_class Replication Server error class based on rs_repserver_error_class, which is the default Replication Server error class:
```
alter replication server error class my_rs_err_class
set template to rs_repserver_error_class
```

Usage

Use the alter error class command and another error class as a template to alter error classes. alter error class copies error actions from the template error class to the error class you want to alter, and overwrites error actions which have the same error code.
The rs_sqlserver_error_class is the default error class provided for Adaptive Server databases while the rs_repserver_error_class is the default error class provided for Replication Server. Initially, these two error classes do not have a primary site. You must create these error classes at a primary site before you can change the default error actions.
You can assign non-Adaptive Server error classes to specific connections on non-Adaptive Server replication databases using the create connection and alter connection commands.
When Replication Server establishes a connection to a non-ASE replicate server, Replication Server verifies if the option to return native error codes from the non-ASE replicate server is enabled for the connection. If the option is not enabled, Replication Server logs a warning message that the connection works but error action mapping may not be correct.

See “ReturnNativeError,” in the Replication Server Options documentation to set the option in the Enterprise Connect™ Data Access (ECDA) Option for ODBC for your replicate server.
For a list of non-Adaptive Server error classes, see Error and function classes. For more information about non-Adaptive Server replication error classes, see the Replication Server Administration Guide Volume 2.