The whenever statement specifies one of the following four 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. |