DROP CURSOR

Purpose

Frees up all system resources allocated to a cursor

Syntax

DROP CURSOR <cursor>

See Also

CLOSE, DECLARE CURSOR, OPEN, SELECT

Description

The DROP CURSOR command frees up all system resources allocated to the specified cursor. Cursors may be closed with the CLOSE statement, and then re-opened with the OPEN statement. The DROP CURSOR statement should only be used if the cursor is no longer needed.

This command can only be used in Embedded SQL. The cursor must already be declared.

Keywords	Description
cursor	The name of a declared cursor to be dropped.

Example

EXEC SQL
  DROP CURSOR accounts;

Products

Recital Server, Recital