Error Class Commands

An error class is a name under which error handling actions—such as retry and ignore—are assigned to specific data server errors.

Use the create connection command to associate an error class with a database. Use alter connection to change an error class. You can often create one error class for all databases for a specified data server.

Note: The default error class for an Adaptive Server database is assigned when you add a connection using rs_init.

Use these commands to manage error handling actions and error classes:

create error class – creates an error class.
alter error class – modifies an existing error class by copying error actions from another error class.
move primary – moves an error class or function-string class and any of the function-string class’ derived classes to a different primary site.
drop error class – drops an error class.
assign action – assigns actions to data server error codes.

Use the stored procedure rs_init_erroractions to initialize a new error class created with error actions from an existing error class. For details, see "Adaptive Server Commands and System Procedures."