SUSPEND

Suspends execution of a select procedure until the next FETCH is issued and returns values to the calling application. Available in stored procedures only.

Syntax: SUSPEND;

Description The SUSPEND statement:

Suspends execution of a stored procedure until the application issues the next FETCH. Returns values of output parameters, if any. A procedure should ensure that all output parameters are assigned values before a SUSPEND. SUSPEND should not be used in an executable procedure. Use EXIT instead to indicate to
the reader explicitly that the statement terminates the procedure.