You can use the extended dynamic DECLARE CURSOR statement:

    o  Embedded in host language programs to be precompiled

    o  As part of a procedure in an SQL module