DECLARE CURSOR

From Recital Documentation Wiki
Revision as of 15:41, 10 November 2009 by Helengeorge (Talk | contribs)

Jump to: navigation, search

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