Difference between revisions of "OPEN"
Helengeorge (Talk | contribs) (→Products) |
Yvonnemilne (Talk | contribs) |
||
| Line 28: | Line 28: | ||
==Example== | ==Example== | ||
<code lang="recital"> | <code lang="recital"> | ||
| − | OPEN accounts | + | OPEN accounts |
</code> | </code> | ||
Latest revision as of 14:37, 22 December 2009
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
Products
Recital Server, Recital
