informix存储过程的问题

[rollstar]

有如下的查询语句
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 换成变量
并能接收手工指定的参数
用存储过程如何做

求教

[帝企鹅已被占用]

手工指定的参数?是什么意思

[rollstar]

就是说 那两个where条件能在执行存储过程前指定，应该是需要声名两个变量。但是怎么声名就不清楚了。

[帝企鹅已被占用]

我给你个SP的头部

DROP PROCEDURE ss_num_day;

CREATE PROCEDURE ss_num_day (
p_dt1 DATETIME YEAR TO SECOND DEFAULT CURRENT YEAR TO SECOND,
p_dt2 DATETIME YEAR TO SECOND,
p_count_time CHAR(1) DEFAULT 'N',
resume_flg CHAR(1) DEFAULT 'N',
trace_flg CHAR(1) DEFAULT 'N')
RETURNING
SMALLINT, -- 0. Status, 0=Sucess
INTEGER, -- 1. num of days
VARCHAR(255); -- -1.Error message
-- Utility stored procedure
-- It return number of days between p_dt1, p_dt2
--
-- If p_dt2 is earily than the p_dt1, a negative values will return
--
-- $SSSVersion: 2.1.1.1 $
-- Created by: Patrick
-------------------------------------------------------------------------------

DEFINE l_number INTEGER;
DEFINE l_day INTERVAL DAY(9) TO DAY;
DEFINE l_str_day CHAR(15);