Embedded SQL for C and SQL Server
Positioned UPDATE or DELETE Statements
Positioned UPDATE and DELETE statements are used in conjunction with cursors and include WHERE CURRENT OF clauses instead of search condition clauses. The WHERE CURRENT OF clause specifies the location of the corresponding cursor.
You can perform a prepared positioned update or a ROLLBACK TRANSACTION operation only on dynamic cursors.
On a cursor declaration that contains a join, you can perform a positioned update or positioned delete only on the first table in the join list.