SQL CLOSE

Purpose

Closes a cursor

Syntax

CLOSE <cursor>

See Also

DECLARE CURSOR, DROP CURSOR, OPEN, SELECT

Description

The CLOSE command closes the specified cursor, releasing all resources and locks allocated when the cursor was opened. A cursor is a pointer to a logical table. A logical table is a temporary collection of data that satisfy conditions specified in a SELECT statement. After a cursor has been CLOSED, it may be accessed again by issuing another OPEN statement. The cursor is not released until a DROP CURSOR statement is issued. This command can only be used in Embedded SQL. The cursor must already be open.

Keywords	Description
cursor	The name of the cursor to be closed.

Example

// Close the cursor
EXEC SQL
CLOSE accounts;

Products

Recital Server, Recital