1  –  variable

    Syntax options:

    variable | string-literal

    Specifies the attribute for the holdable cursor. Values can
    include:

    o  ON COMMIT

       All cursors declared without a WITH HOLD clause or with a WITH
       HOLD ON COMMIT clause remain open when you commit.

    o  ON ROLLBACK

       All cursors declared without a WITH HOLD clause or with a WITH
       HOLD ON ROLLBACK clause remain open when you roll back.

    o  ALL

       All cursors remain open with the exception of those declared
       with a WITH HOLD clause.

    o  NONE

       All cursors close with the exception of those declared with a
       WITH HOLD clause.

       This is the default if you do not specify a SET HOLD CURSORS
       statement.