Was this helpful?
Considerations
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.
Last modified date: 01/30/2023