DELETE (positioned) statement [ESQL] [SP]

Description

Deletes the data at the current location of a cursor.

Syntax

DELETE
WHERE CURRENT OF cursor-name

Parameters

cursor-name:: identifier | hostvar

Examples

Example 1

The following statement removes the current row from the database:

DELETE WHERE CURRENT OF cur_employee

Usage

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 positioned DELETE statement can be used on a cursor open on a view as long as the view is updatable.

Changes effected by positioned DELETE statements are visible in the cursor result set, except where client-side caching prevents seeing these changes.

Standards

SQL92 Entry-level feature. The range of cursors that can be updated may contain vendor extensions if the ANSI_UPDATE_CONSTRAINTS option is set to OFF.

SQL99 Core feature. The range of cursors that can be updated may contain vendor extensions if the ANSI_UPDATE_CONSTRAINTS option is set to OFF.

Sybase Embedded SQL use is supported by Open Client/Open Server. Procedure and trigger use is supported in Adaptive Server Anywhere.

Permissions

Must have DELETE permission on tables used in the cursor.