Do not use an EXECUTE, SELECT, or WITH keyword as the name of a cursor. If you try to use one of these keywords as the name of a cursor in a FOREACH statement, the cursor name is interpreted as a keyword in the FOREACH statement. No workaround exists.
The following example does not work:
DEFINE execute INT; FOREACH execute FOR SELECT col1 -- error, looks like -- FOREACH EXECUTE PROCEDURE INTO var1 FROM tab1;Enterprise Edition Home | Express Edition Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]