Managing a cursor is similar to managing a file in a programming language. The following steps manage cursors:
Declare a cursor for a particular SELECT statement or procedure using the DECLARE statement.
Open the cursor using the OPEN statement.
Use the FETCH statement to retrieve results one row at a time from the cursor.
A row not found warning signals the end of the result set.
Close the cursor using the CLOSE statement.
By default, cursors are automatically closed at the end of a transaction (on COMMIT or ROLLBACK statements). Cursors opened using the WITH HOLD clause will stay open for subsequent transactions until explicitly closed.
Discuss this page in DocCommentXchange.
|Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1|