Navigation:  NexusDB Guide > SQL Reference > SQL Statements > Data Statements >

CLOSE statement

Previous pageReturn to chapter overviewNext page

NexusDB V3 Manual

CLOSE statement

button_main button_prev button_next

NexusDB Manual V3 > SQL Reference > SQL Statements > Data Statements

 

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"

 

© Nexus Database Systems Pty Ltd.

nexus_logo