CLOSE (insert cursor)

Flushes and closes an insert cursor.

Syntax

CLOSE cid
  1. cid is the identifier of the insert cursor.

Usage

If rows are present in the insert buffer, they are inserted into the target table.

Closing the insert cursor 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.