• A retrieve cursor can only be issued if cursor_name has been declared and is currently open.

• There must be a one-to-one correspondence between variables specified in the retrieve cursor target list and columns in the retrieve clause of the declare cursor statement. The preprocessor generates a warning if there is a mismatch between the cursor declaration and its use in a retrieve cursor statement.

• The retrieve cursor statement also has a param version in some host languages. For more information on param statements, see the Embedded QUEL Companion Guide.