SET CLOSECURSOR

Purpose

Sets the cursor usage behavior.

Syntax

SET CLOSECUR[SOR] {OFF|ON}

Usage Notes

On or OFF sets whether or not the cursor will close and reopen after each SQL statement. This feature may be useful in some circumstances to release resources in the database server.