請問AS400上如何調用帶參數的存儲過程?

forgot2000

CREATE PROCEDURE GetCusName(IN Cusname VARCHAR( )
   RESULT SETS 1
   LANGUAGE SQL
BEGIN
     DECLARE c1 CURSOR WITH RETURN FOR
     SELECT cusnam FROM customer=Cusname ORDER BY cusnam;
     OPEN c1;
END



如上存儲過程是否有問題？為什麼可以建立，但無法調用 ？我用Call TestLib.GetCusName(‘myname’)會出錯？

tme45

？SELECT cusnam FROM customer=Cusname ORDER BY cusnam;

这样写好象有问题吧，　select fld1 from table where cond order by fld1