CLOSE (insert cursor)

Flushes and closes an insert cursor.

Syntax

CLOSE cid
  1. 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.