Difference between revisions of "OPEN"
Yvonne.milne (Talk | contribs) m (1 revision: SQL) |
Helen.george (Talk | contribs) |
||
| Line 1: | Line 1: | ||
==Purpose== | ==Purpose== | ||
Opens a pointer to a logical table | Opens a pointer to a logical table | ||
| − | |||
==Syntax== | ==Syntax== | ||
OPEN <cursor> | OPEN <cursor> | ||
| − | |||
==See Also== | ==See Also== | ||
[[SQL CLOSE|CLOSE]], [[DECLARE CURSOR]], [[DROP CURSOR]], [[FETCH]] | [[SQL CLOSE|CLOSE]], [[DECLARE CURSOR]], [[DROP CURSOR]], [[FETCH]] | ||
| − | |||
==Description== | ==Description== | ||
| Line 15: | Line 12: | ||
This command can only be used in Embedded SQL. The cursor must already be declared. | This command can only be used in Embedded SQL. The cursor must already be declared. | ||
| − | |||
| − | |||
{| class="wikitable" | {| class="wikitable" | ||
| Line 24: | Line 19: | ||
|- | |- | ||
|} | |} | ||
| − | |||
==Example== | ==Example== | ||
| Line 31: | Line 25: | ||
</code> | </code> | ||
| − | |||
| − | |||
| − | |||
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:SQL]] | [[Category:SQL]] | ||
[[Category:Commands]] | [[Category:Commands]] | ||
Revision as of 10:03, 7 December 2012
Contents
Purpose
Opens a pointer to a logical table
Syntax
OPEN <cursor>
See Also
CLOSE, DECLARE CURSOR, DROP CURSOR, FETCH
Description
The OPEN statement opens a cursor (a pointer to a logical table) that has been declared with the DECLARE CURSOR statement. The DECLARE CURSOR statement declares a cursor which may be processed in an application program. A logical table is a temporary collection of data that satisfies conditions specified in a SELECT statement. Once a declared cursor has been opened, the FETCH statement may be used to obtain values from the rows of its logical table. The CLOSE statement is used to close an open cursor. Cursors may be opened and closed repeatedly until the cursor is released with the DROP CURSOR statement. Cursors are also released when RECITAL is exited. The OPEN statement opens the cursor on the first row of its logical table, regardless of which row it was on when last closed.
This command can only be used in Embedded SQL. The cursor must already be declared.
| Keywords | Description |
|---|---|
| cursor | The name of the cursor to be opened. |
Example
OPEN accounts