Use this statement to delete the data at the current location of a cursor.
DELETE [ FROM table-spec ] WHERE CURRENT OF cursor-name
cursor-name : identifier | hostvar
table-spec : [ owner.]correlation-name
owner : identifier
This form of the DELETE statement deletes the current row of the specified cursor. The current row is defined to be the last row fetched from the cursor.
The table from which rows are deleted is determined as follows:
Must have DELETE permission on tables used in the cursor.
SQL/2003 Core feature. The range of cursors that can be updated may contain vendor extensions if the ansi_update_constraints option is set to Off.
The following statement removes the current row from the database.
DELETE WHERE CURRENT OF cur_employee;
|Send feedback about this page via email or DocCommentXchange||Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0|