whenever actions

The whenever statement specifies one of the following four actions:

Table 8-4: whenever actions

Action

Description

continue

Perform no special action when a SQL statement returns the specified condition. Normal processing continues.

goto

Perform a branch to an error handling procedure within your application program. You can write goto as either goto or go to, and you must follow it with a valid statement label name. The precompiler does not detect an error if the label name is not defined in the program, but the C compiler does.

call

Call another C routine and, optionally, pass variables.

stop

Terminate the program when a SQL statement triggers the specified condition.