谁帮忙看看这段存储过程
create procedure dataadd3
begin
declare hou integer default 15;
declare min integer default 10;
declare sec integer default 20;
declare cur varchar(3) default '446';
declare cardno varchar(13) default '6225087600981';
declare cardseq integer default 90001;
declare i integer default 0;
declare systra integer default 1000;
declare tots varchar(26) default '';
declare time integer default 100001;
while i<3000 do
set tots = '2010-06-04 14:40:10.'||CHAR(time);
update AR_DTCDB.TBL_ARDTC_CUPS_TRANS_COLLECT1
set TO_TS = tots,
acpt_ins_cntry_cd = cur,
sys_tra_no = '09'||CHAR(systra),
AR_PRI_ACCT_NO = cardno||CHAR(cardseq)
where to_ts = '2010-07-01 11:15:10.000000';
set sec = sec+1;
set i = i+1;
set systra = systra+1;
set time = time+1;
end while;
end;
×××××××××××××××××××××××××××××××××××××××××××××××
问题:
set sec = sec+1;
set i = i+1;
set systra = systra+1;
set time = time+1;
这几句没起作用,UPDATE后,检查了所有,值都一样。。。。
我是想没改1行自加1的