CLOSE (insert cursor)
Flushes and closes an insert cursor.
Syntax
CLOSE cid
- cid is the identifier of the insert cursor.
Usage
Closing the insert cursor flushes automatically the rows remaining in the insert buffer, and releases the resources allocated for the insert buffer on the database server.
After using the CLOSE
instruction, you must reopen the cursor with OPEN
before adding new rows with PUT
/FLUSH
.