Close

Syntax

CLOSE Identifier

Description

Closes the named cursor. The cursor must have previously been successfully created with the ij Get Cursor or Get Scroll Insensitive Cursor commands.

Example

ij> get cursor menuCursor as 'SELECT * FROM menu';
ij> next menuCursor;
COURSE     |ITEM                |PRICE          
-----------------------------------------------
entree     |lamb chop           |14
ij> next menuCursor;
COURSE     |ITEM                |PRICE          
-----------------------------------------------
dessert    |creme brulee        |6              
ij> close menuCursor;
ij>
Related concepts
ij commands
ij errors
Related reference
Absolute
After Last
Async
Autocommit
Before First
Commit
Connect
Disconnect
Driver
Elapsedtime
Execute
Exit
First
Get Cursor
Get Scroll Insensitive Cursor
Help
Last
LocalizedDisplay
MaximumDisplayWidth
Next
Prepare
Previous
Protocol
Readonly
Relative
Remove
Rollback
Run
Set Connection
Show Connections
Wait For
Comment
Identifier
String