close

Closes the named cursor.

Syntax

CLOSE Identifier

Description

Closes the named cursor. The cursor must have previously been successfully created with the sqlf Get Scroll Insensitive Cursor command.

Example

sqlf(PEERCLIENT)> get scroll insensitive with nohold cursor scrollCursor as 'select * from firsttable order by id';
sqlf(PEERCLIENT)> before first scrollCursor;
No current row
sqlf(PEERCLIENT)> GETCURRENTROWNUMBER scrollCursor;
0
sqlf(PEERCLIENT)> relative 2 scrollCursor;
ID         |NAME
------------------------
20         |TWENTY
sqlf(PEERCLIENT)> GETCURRENTROWNUMBER scrollCursor;
2
sqlf(PEERCLIENT)> close scrollCursor;