EXEC SQL DECLARE CSR CURSOR FOR SELECT C1, C2, C3, SUM(C4) FROM T1
WHERE C5 = :HV5 AND C6 = :HV6 GROUP BY C1, C2, C3 END-EXEC.
EXEC SQL OPEN CSR END-EXEC.
EXEC SQL FETCH CSR INTO :HV1, :HV2, :HV3, :HV4 END-EXEC.

- will it run the first time?
- close the cursor immediately?