Event handlers execute on a separate connection from the action that triggered the event, and so do not interact with client applications. They execute with the privileges of the creator of the event.
Event handlers, whether for scheduled events or for system event handling, contain compound statements, and are similar in many ways to stored procedures. You can add loops, conditional execution, and so on, and you can use the SQL Anywhere debugger to debug event handlers.
After each execution of an event handler, a COMMIT occurs if no errors occurred. A ROLLBACK occurs if there was an error.
How the database server checks for system events
How the database server checks for scheduled events
How event handlers are executed
Creating a database event
Triggering an event handler
Debugging an event handler
Hiding an event handler
Discuss this page in DocCommentXchange.
|Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0|