Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 17 » SQL Anywhere Server - SQL Reference » SQL statements » Alphabetical list of SQL statements

RESUME statement

Resumes execution of a cursor that returns result sets.

RESUME cursor-name
cursor-name :  identifier | hostvar

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.

The cursor must have been previously opened.



Side effects


  • ANSI/ISO SQL Standard

    Not in the standard.


Following are Embedded SQL examples.

EXEC SQL RESUME cur_employee;
EXEC SQL RESUME :cursor_var;