光标应用例一返回多行的Sect EXEC SQL OPEN cl EXEC SQL SELECT SUM(Sal) into s sal from emp while(s sal < 500000.00) EXEC SQL FETCH FROM CI INTO: e sno, e sal f( SQLSTATE=02000) BREAK;/读完职工记录, 退出循环* EXEC SQL UPDATE emp SET sal=sal* 1.1 WHERE eno= e eno s sa s sal +e sal i 0.1 EXEC SQL CLOSE CI光标应用例－返回多行的select EXEC SQL OPEN c1 ; EXEC SQL SELECT SUM(sal) into :s_sal from emp ; while (s_sal < 500000.00) { EXEC SQL FETCH FROM c1 INTO :e_sno , :e_sal ; if(SQLSTATE=='02000') BREAK ; /*读完职工记录， 退出循环*/ EXEC SQL UPDATE emp SET sal=sal*1.1 WHERE eno=:e_eno; s_sal = s_sal + e_sal * 0.1 ; }; EXEC SQL CLOSE c1 ; }