Difference between revisions of "DECLARE CURSOR"
Yvonnemilne (Talk | contribs) |
Yvonnemilne (Talk | contribs) |
||
| Line 1: | Line 1: | ||
| − | |||
| − | |||
| − | |||
==Class== | ==Class== | ||
SQL Applications | SQL Applications | ||
| Line 16: | Line 13: | ||
==See Also== | ==See Also== | ||
| − | [[SQL CLOSE|CLOSE]], [[DROP CURSOR]], [[FETCH]], [[OPEN]], [[SQL SELECT|SELECT]] | + | [[SQL CLOSE|CLOSE]], [[DROP CURSOR]], [[FETCH]], [[SQL INSERT|INSERT]], [[OPEN]], [[SQL SELECT|SELECT]] |
| Line 45: | Line 42: | ||
// Declare the cursor to select records from the accounts table | // Declare the cursor to select records from the accounts table | ||
EXEC SQL | EXEC SQL | ||
| − | DECLARE accounts CURSOR FOR | + | DECLARE accounts CURSOR FOR |
| − | SELECT name,address,ord_value,balance | + | SELECT name,address,ord_value,balance |
| − | FROM accounts | + | FROM accounts |
| − | ORDER BY name; | + | ORDER BY name; |
</code> | </code> | ||
Revision as of 11:00, 28 April 2009
Class
SQL Applications
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
