DELETE (positioned) Statement [ESQL] [SP]

Quick Links:

Syntax

DELETE [ FROM table-spec ]
   WHERE CURRENT OF cursor-name

table-spec - (back to Syntax)
   [ owner.]correlation-name

cursor-name - (back to Syntax)
   identifier | hostvar

Parameters

(back to top)

FROM – the table FROM which rows are deleted is determined as follows:
- If no FROM clause is included, the cursor can only be on a single table.
- If the cursor is for a joined query (including using a view containing a join), you must use the FROM clause. Only the current row of the specified table is deleted. The other tables involved in the join are not affected.
- If you include a FROM clause and do not specify table owner, table-spec is first matched against any correlation names.
  - If a correlation name exists, table-spec is identified with the correlation name.
  - If a correlation name does not exist, table-spec must be unambiguously identifiable as a table name in the cursor.
- If a FROM clause is included, and a table owner is specified, table-spec must be unambiguously identifiable as a table name in the cursor.

Examples

(back to top)

Example 1 – removes the current row from the database:
```
DELETE WHERE CURRENT OF cur_employee
```

Usage

(back to top)

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

(back to top)

SQL—The range of cursors that can be updated may contain vendor extensions to ISO/ANSI SQL grammar if the ANSI_UPDATE_CONSTRAINTS option is set to OFF.
SAP Sybase Database product—Embedded SQL use is supported by Open Client/Open Server. Procedure and trigger use is supported in SQL Anywhere.

Permissions

(back to top)

Requires DELETE privilege on tables used in the cursor.