DELETE (positioned)
Use the positioned DELETE statement to remove the current row of a view associated with a SQL cursor.
Syntax
DELETE WHERE CURRENT OF cursor-name
cursor-name ::= user-defined-name
Remarks
This statement is allowed in stored procedures, triggers, and at the session level.
Note Even though positioned DELETE is allowed at the session level, the DECLARE CURSOR statement is not. The method to obtain the cursor name of the active result set depends on the PSQL access method your application uses. See the PSQL documentation for that access method.
Examples
The following sequence of statements provide the setting for the positioned DELETE statement. The required statements for the positioned DELETE statement are DECLARE CURSOR, OPEN CURSOR, and FETCH FROM cursorname.
The Modern European History class has been dropped from the schedule, so this example deletes the row for Modern European History (HIS 305) from the Course table in the sample database:
CREATE PROCEDURE DropClass();
DECLARE :CourseName CHAR(7);
DECLARE c1 cursor
FOR SELECT name FROM course WHERE name = :CourseName;
BEGIN
SET :CourseName = 'HIS 305';
OPEN c1;
FETCH NEXT FROM c1 INTO :CourseName;
DELETE WHERE CURRENT OF c1;
END;
See Also