Reference Manual
   CHAPTER 9. SQL Statements     

RESUME statement

Function 

To resume a procedure following a query.

Syntax 1 

RESUME cursor-name

Syntax 2 

RESUME [ ALL ]

Parameters 

cursor-name: identifier

cursor-name: identifier or host-variable

Permissions 

The cursor must have been previously opened.

Side effects 

None.

See also 

DECLARE CURSOR statement

Returning results from procedures

Description 

This statement resumes execution of a procedure that returns result sets. The procedure executes until the next result set (SELECT statement with no INTO clause) is encountered. If the procedure completes and no result set is found, the SQLSTATE_PROCEDURE_COMPLETE warning is set. This warning is also set when you RESUME a cursor for a SELECT statement.

The Interactive SQL RESUME statement (Format 2) resumes the current procedure. If ALL is not specified, executing RESUME displays the next result set or, if no more result sets are returned, completes the procedure.

The Interactive SQL RESUME ALL statement cycles through all result sets in a procedure, without displaying them, and completes the procedure. This is useful mainly in testing procedures.

Standards and compatibility 

• SQL/92     Vendor extension.

• Sybase     Not supported by Adaptive Server Enterprise.

Examples 

• Embedded SQL example

  1. EXEC SQL RESUME cur_employee;
  2. EXEC SQL RESUME :cursor_var;

• Interactive SQL examples

  CALL sample_proc() ;
  RESUME ALL;