ASA SQL Reference
  SQL Statements

RESUME statement

Description 

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

Syntax 

RESUME cursor-name

cursor-name :  identifier or hostvar

Usage 

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.

Permissions 

The cursor must have been previously opened.

Side effects 

None.

See also 

DECLARE CURSOR statement [ESQL] [SP]

Returning results from procedures

Standards and compatibility 

• SQL/92    Vendor extension.

• SQL/99    Vendor extension.

• Sybase    Not supported by Adaptive Server Enterprise.

Example 

Following are Embedded SQL examples.

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

Following is an Interactive SQL example.

CALL sample_proc();
RESUME ALL;