<open statement> ::=

OPEN <cursor-name>


The cursor is opened and references a set of rows in accordance with the definition of the cursor.


SQL cursor names shall conform to the rules for identifiers in NexusDB SQL
A cursor must be declared with a DECLARE CURSOR statement before it may be opened.
The result-set is defined when the OPEN statement is executed, any inserts, updates or deletes occurring after the open will not be reflected in the result-set.
Open cursors can be closed using the CLOSE statement
The cursor is placed `before' the first row in the addressed set.


1) The following example executes a simple query:

       OPEN studentCursor;


SQL:2003 standard


Feature F431, "Read-only scrollable cursors"

Home | Site Contents | Documentation | NexusDB Manual V4 | SQL Reference | SQL Statements | Data Statements