Default Handling of Errors and Warnings in Procedures

Errors and warnings are handled differently in procedures.

The default action for errors is to set a value for the SQLSTATE and SQLCODE variables, and return control to the calling environment in the event of an error, the default action for warnings is to set the SQLSTATE and SQLCODE values and continue execution of the procedure.

See SQL Anywhere Server - SQL Usage > Stored Procedures and Triggers > Using procedures, triggers, and batches > Errors and warnings in procedures and triggers > Default handling of warnings in procedures and triggers.

Note: This reference points to SQL Anywhere documentation.
Note: Sybase IQ does not support triggers. You can ignore information about triggers in the SQL Anywhere documentation.