Globally Affecting Cursors with SET AUTOFREE

If you include no FOR cursor_id or FOR cursor_id_var clause, then the scope of SET AUTOFREE is all subsequently-declared cursors in the program (or more precisely, all cursors declared before a subsequent SET AUTOFREE statement with no FOR clause globally resets the Autofree feature). This example enables the Autofree feature for all subsequent cursors in the program:

EXEC SQL set autofree;

The next example disables the Autofree feature for all subsequent cursors:

EXEC SQL set autofree disabled;