linux db2
CREATE PROCEDURE "DB2INST"."PROC_TRANS_EMBASSY_2" ( )begin declare v_cname varch
ar(50);--declare v_ename varchar(50);--declare v_cno varchar(10);--declare v_eno
varchar(10);--declare v_at_end integer default 0;--declare not_found condition
for sqlstate '02000';--declare cursor_get cursor for select C_COUNTRY_NUM from
T_COUNTRY_EMBASSY GROUP BY C_COUNTRY_NUM HAVING COUNT(*)>1;--declare continue
handler for not_found set v_at_end = 1;--open cursor_get;--loop1:loop fetch cur
sor_get into v_cno;--if v_at_end = 1 then leave loop1;--end if;--set v_cname = (
select C_COUNTRY_NAME from T_COUNTRY_EMBASSY WHERE C_COUNTRY_NUM = v_cno AND C_E
MBASSY_NAME LIKE '驻%使馆');--update T_COUNTRY_EMBASSY SET C_COUNTRY_NAME = v_c
name where C_COUNTRY_NUM = v_cno;--end loop loop1;--close cursor_get;--end
DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL0104N An unexpected token "END-OF-STATEMENT" was found following "v_cname
varchar(50);". Expected tokens may include: "END". LINE NUMBER=1.
SQLSTATE=42601