informix存储过程的问题
有如下的查询语句
select a.ma_csid, b.cs_linkaddress, a.ma_actioninfo,
b.cs_businesstype,(to_date(a.ma_ac_do_dt) - to_date(b.cs_create_dt)) as time,
a.ma_col1, (select usr_name from sys_user where a.ma_col3 = usr_id) as ma_col3, b.cs_linkphone
from t_missionactionotherinfo a, t_case b
where a.ma_csid = b.cs_busiid and a.ma_ac_do_dt > '2011-11-03' and a.ma_ac_type = 2;
把where条件中的 a.ma_ac_do_dt > '2011-11-03' 和 a.ma_ac_type = 2 当中的 '2011-11-03' 和 2 换成变量
并能接收手工指定的参数
用存储过程如何做
求教