Difference between revisions of "DECLARE CURSOR"

Revision as of 15:41, 10 November 2009

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.

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