存储过程中运算符如何使用？？？
本帖最后由 y331044508 于 2011-10-10 17:30 编辑informix 版本：15.6创建table3
CREATE TABLE table3
(
yjid integer PRIMARY KEY,
mustyj float,
realityyj float,
percentyj float
);
insert into table3 (yjid,mustyj,realityyj,percentyj) values ('1','10','8.9','');
insert into table3 (yjid,mustyj,realityyj,percentyj) values ('2','10','7.9','');
insert into table3 (yjid,mustyj,realityyj,percentyj) values ('3','10','8.4','');
insert into table3 (yjid,mustyj,realityyj,percentyj) values ('4','10','8.3','');
insert into table3 (yjid,mustyj,realityyj,percentyj) values ('5','10','7.3','');
--6、计算员工的业绩百分比
drop procedure table_function;
create procedure table_function()
yjid_v integer;
mustyj_v float;
realityyj_v float;
percentyj_v float;
let percentyj_v =''
while percentyj_v =''
select first 1 yjid,mustyj,realityyj,percentyj into yjid_v,mustyj_v,realityyj_v,percentyj_v from table3 where percentyj='';
--计算出realityyj_v / mustyj_v = percentyj_v 这里如何写？
updata table2 set percentyj=percentyj_v where yjid=yjid_v;
end while;
end procedure; 刚开始学习这个，还希望前辈们多多指教，看看我这个存储写的是不是不够简洁。
再是希望能够给我说下具体的存储过程中如何使用运算符，谢谢。 难道是我没表达清楚意思吗？怎么没人呢？？？ realityyj_v / mustyj_v = percentyj_v 怎么计算出这个值呢:dizzy:怎么写呢？ 本帖最后由 y331044508 于 2011-10-10 17:32 编辑
create procedure table_function()
define yjid_v integer;
define mustyj_v float;
define realityyj_v float;
define percentyj_v float;
define i integer;
define x integer;
select count(*) into i from table3 where percentyj is null;
for x =1 to i
select first 1 yjid,mustyj,realityyj into yjid_v,mustyj_v,realityyj_v from table3 where percentyj is null;
let percentyj_v =realityyj_v/mustyj_v;
update table3 set percentyj=percentyj_v where yjid=yjid_v;
end for;
end procedure;:dizzy:搞了半天才搞出来 let 变量=公式
btw: lz的informix版本很牛呀，穿越回来的？
页:
[1]