You can use the SET HOLD CURSORS statement:

    o  In interactive SQL

    o  Embedded in host language programs to be precompiled to change
       the behavior of dynamic cursors

    o  As part of a procedure in an SQL module

    o  In dynamic SQL as a statement to be dynamically executed