Difference between revisions of "DECLARE CURSOR"
Yvonnemilne (Talk | contribs) |
Helengeorge (Talk | contribs) |
||
| Line 1: | Line 1: | ||
| − | |||
| − | |||
| − | |||
| − | |||
==Purpose== | ==Purpose== | ||
Declares a pointer to a logical table | Declares a pointer to a logical table | ||
Revision as of 10:55, 23 October 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.
| 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 Database Server, Recital Mirage Server, Recital Terminal Developer
