RESUME statement

Use this statement to resume execution of a cursor that returns result sets.

Syntax
RESUME cursor-name
cursor-name :  identifier | hostvar
Remarks

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 RESUME statement is not supported in Interactive SQL. If you want to view multiple result sets in Interactive SQL, you can set the isql_show_multiple_result_sets option to ON, or choose Tools » Options, and then select Show Multiple Result sets on the Results tab.

Permissions

The cursor must have been previously opened.

Side effects

None.

See also
Standards and compatibility
  • SQL/2003   Vendor extension.

Example

Following are embedded SQL examples.

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