OPEN statement

Mon, 03/09/2009 - 21:59 |  hdanzl


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"
‹ DECLARE CURSOR statementupCLOSE statement ›
Print this chapter |  Login or register to post comments |  Send to friend |  PDF version |  metadata Tags:
Home | Site Contents | Documentation | NexusDB Manual V4 | SQL Reference | SQL Statements | Data Statements

Powered by Drupal and Drupal Theme created with Artisteer.