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 Sybase IQ debugger to debug event handlers.
See”Developing event handlers” in SQL Anywhere Server - SQL Usage.
For more information, see “EVENT_PARAMETER function [System]” in Chapter 4, “SQL Functions,” in Reference: Building Blocks, Tables, and Procedures.
For an example on using event handling, see “Managing IQ user accounts and connections” in “Automating Tasks Using Schedules and Events,” in the System Administration Guide: Volume 1.