CLOSE (insert cursor)
Flushes and closes an insert cursor.
Syntax
CLOSE cid
- 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
.