Managing a cursor is similar to managing a file in a programming language. The following steps manage cursors:
Row Not Foundsignals the end of the result set.
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.
For more information about positioning cursors, see Cursor positioning.
|Send feedback about this page via email or DocCommentXchange||Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0|