DECLARE CURSOR

Purpose

Declares a pointer to a logical table

Syntax

DECLARE <cursor> [READ ONLY | INSERT ONLY] [TABLE] CURSOR FOR SELECT <statement>

See Also

CLOSE, DROP CURSOR, FETCH, INSERT, OPEN, SELECT

Description

The DECLARE CURSOR command declares a cursor to represent the active set of rows specified by a SELECT or INSERT statement. It declares a cursor (a pointer to a logical table) to be processed in an application program. A logical table is a temporary collection of data that satisfy conditions specified in a SELECT statement. Declared cursors are opened with the OPEN statement and closed with the CLOSE statement. After a cursor has been CLOSED, it may be accessed again by issuing another OPEN statement. A cursor is not released until a DROP CURSOR statement is issued.

This command can only be used in Embedded SQL. The cursor cannot already be open.

Keywords	Description
cursor	The name of the cursor to be opened.
READ ONLY	The cursor is opened read only.
INSERT ONLY	The cursor is opened for inserts only.
TABLE	This is for compatibility only.
SELECT statement	This is a SELECT statement to be associated with the cursor. The select statement cannot contain an INTO clause.

Example

// Declare the cursor to select records from the accounts table
EXEC SQL
    DECLARE accounts CURSOR FOR
      SELECT name,address,ord_value,balance
      FROM accounts
      ORDER BY name;

Products

Recital Server, Recital