Difference between revisions of "DECLARE CURSOR"
Yvonne.milne (Talk | contribs) m (1 revision: SQL) |
Helen.george (Talk | contribs) |
||
| Line 1: | Line 1: | ||
==Purpose== | ==Purpose== | ||
Declares a pointer to a logical table | Declares a pointer to a logical table | ||
| − | |||
==Syntax== | ==Syntax== | ||
DECLARE <cursor> [READ ONLY | INSERT ONLY] | DECLARE <cursor> [READ ONLY | INSERT ONLY] | ||
[TABLE] CURSOR FOR SELECT <statement> | [TABLE] CURSOR FOR SELECT <statement> | ||
| − | |||
==See Also== | ==See Also== | ||
[[SQL CLOSE|CLOSE]], [[DROP CURSOR]], [[FETCH]], [[SQL INSERT|INSERT]], [[OPEN]], [[SQL SELECT|SELECT]] | [[SQL CLOSE|CLOSE]], [[DROP CURSOR]], [[FETCH]], [[SQL INSERT|INSERT]], [[OPEN]], [[SQL SELECT|SELECT]] | ||
| − | |||
==Description== | ==Description== | ||
| Line 16: | Line 13: | ||
This command can only be used in Embedded SQL. The cursor cannot already be open. | This command can only be used in Embedded SQL. The cursor cannot already be open. | ||
| − | |||
{| class="wikitable" | {| class="wikitable" | ||
| Line 32: | Line 28: | ||
|- | |- | ||
|} | |} | ||
| − | |||
==Example== | ==Example== | ||
| Line 45: | Line 40: | ||
| − | |||
| − | |||
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:SQL]] | [[Category:SQL]] | ||
[[Category:Commands]] | [[Category:Commands]] | ||
Revision as of 07:57, 7 December 2012
Contents
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 DECLARE accounts; CURSOR FOR; SELECT name, address, ord_value, balance; FROM accounts; ORDER BY name
