Free cursor resources

The CLOSE statement explicitly frees resources assigned to the insert cursor. However, the cursor ID still exists, so you can reopen the cursor with the OPEN statement. The FREE statement explicitly frees the cursor ID. To reuse the cursor, you must declare the cursor again with the DECLARE statement.

The FLUSH statement does not effect an insert cursor that is associated with a collection variable. For the syntax of the CLOSE statement, see the HCL OneDB™ Guide to SQL: Syntax.