c语言调用db2存储过程,DB2中如何用一个存储过程调用其他存储过程？

CREATE PROCEDURE P_FIX_ORDER_INFO (

IN "BEGIN_IN_DATE" VARCHAR(10) ,-- 开始日期

IN "END_IN_DATE" VARCHAR(10) -- 结束日期

)

DYNAMIC RESULT SETS 1

P1: BEGIN

DECLARE V_BEGIN_DATE date;

DECLARE V_END_DATE date;

set V_BEGIN_DATE = to_date(BEGIN_IN_DATE,'YYYY-MM-DD');

set V_END_DATE = to_date(END_IN_DATE,'YYYY-MM-DD');

while V_BEGIN_DATE <= V_END_DATE do

call P_IMPORT_ORDERINFO(V_BEGIN_DATE);

call P_ORDER_SELL_DAY_CLIENT_CIG(V_BEGIN_DATE);

call P_ORDER_SELL_DAY_CLIENT(V_BEGIN_DATE);

set V_BEGIN_DATE = V_BEGIN_DATE + 1 day;

end while;

END P1 ;收起