ERROR | USING clause can only be used on a PREPAREd dynamic statement |
CAUSE | A severe semantics error occurred because the USING clause was used with the OPEN cursor statement and the cursor declaration is not for a PREPAREd statement. The correct sequence of statements should be like: EXEC SQL prepare sv from : sel_stmt END-EXEC. EXEC SQL declare csv cursor for sv END-EXEC. EXEC SQL open csv USING : hv1, : hv2 END-EXEC. |
ACTION | Use the prepare statement for the sql statement and use that in the declare cursor statement. |