NexusDB Guide > SQL Reference > SQL Statements > Data Statements

NexusDB V3 Manual

OPEN statement

Syntax

<open statement> ::=

OPEN <cursor-name>

Usage

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

Notes

§	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.

Examples

1) The following example executes a simple query:

OPEN studentCursor;

Conformance

SQL:2003 standard

Feature F431, "Read-only scrollable cursors"

nexus_logo