CREATE PROCEDURE TESTFOR()
LANGUAGE SQL
BEGIN
DECLARE V_TEMP1 VARCHAR(2);
DECLARE V_TEMP2 VARCHAR(70);
FOR V1 AS CURSOR1 CURSOR FOR
SELECT STUDENT_ID AS TEMP1,STUDENT_NAME AS TEMP2 FROM STUDENT
DO
DELETE FROM STUDENT WHERE STUDENT_ID = V1.TEMP1;
SET V_TEMP1 = V1.TEMP1;
SET V_TEMP2 = V1.TEMP2;
END FOR;
COMMIT;
END;
報錯[-104] 在 "END" 后面找到例外標記 "END-OF-STATEMENT"。預期標記可能包括："JOIN <joined_table>"。. SQLCODE=-104, SQLSTATE=42601, DRIVER=3.64.106
[-104] 在 "1.TEMP2" 后面找到例外標記 "END-OF-STATEMENT"。預期標記可能包括："
END FOR"。. SQLCODE=-104, SQLSTATE=42601, DRIVER=3.64.106
uj5u.com熱心網友回復：
建議你參考下：https://blog.csdn.net/wangjichen_1/article/details/60959144轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/86698.html
標籤：DB2
上一篇：新人求助！！！
下一篇：一個不解的問題，請解答