Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
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 stay open for subsequent transactions until explicitly closed.
Discuter à propos de cette page dans DocCommentXchange.
|Copyright © 2013, SAP AG ou société affiliée SAP - SAP Sybase SQL Anywhere 16.0|