Sybase Adaptive Server Anywhere - RESUME Statement

RESUME statement
592
RESUME statement
Use this statement to resume execution of a cursor that returns result sets.
RESUME cursor-name
cursor-name
: identifier
cursor-name
: identifier or host-variable
The cursor must have been previously opened.
None.
"DECLARE CURSOR statement" on page 488
"Returning results from procedures" on page 466 of the book ASA User’s
Guide
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.
♦
SQL/92 Vendor extension.
♦
Sybase Not supported by Adaptive Server Enterprise.
♦ Embedded SQL example
1. EXEC SQL RESUME cur_employee;
2. EXEC SQL RESUME :cursor_var;
♦ Interactive SQL examples
CALL sample_proc();
RESUME ALL;
Function
Syntax 1
Permissions
Side effects
See also
Description
Standards and
compatibility
Examples