PCC-02445: USING clause valid only on a PREPAREd dynamic statement

PCC-02445: USING clause valid only on a PREPAREd dynamic statement

Cause: The USING clause was used with an OPEN cursor statement where the cursor declaration was not for a PREPAREd statement. The correct sequence of statements should be as follows EXEC SQL PREPARE s FROM :stmt; EXEC SQL DECLARE c CURSOR FOR s; EXEC SQL OPEN c USING ...;

Action: Use the PREPARE statement for the SQL statement and use that in the DECLARE CURSOR statement.