CLOSE statement

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


Syntax

<close statement> ::=

CLOSE <cursor-name>


Usage

The current state of the named cursor is closed and all resources are released.


Notes

♦ SQL cursor names shall conform to the rules for identifiers in NexusDB SQL
♦ For the statement to be valid, the cursor in question must be open.

Examples

1) The following example executes a simple query:

       CLOSE studentCursor;


Conformance

SQL:2003 standard

-

Feature F431, "Read-only scrollable cursors"
‹ OPEN statementupFETCH statement ›
Print this chapter |  Login or register to post comments |  Send to friend |  PDF version |  metadata Tags:
Home | Site Contents | Documentation | NexusDB Manual V3 | SQL Reference | SQL Statements | Data Statements

Powered by Drupal and Drupal Theme created with Artisteer.