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.
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.
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 Chapter 5, “Adaptive Server Commands and System Procedures.”