Am trying to run a sql stored procedures in DB2 from Asp or .Net front end.
I have created a store procedure as follows
CREATE PROCEDURE MM.INTERSP
IN INDATE DATE
,IN INTYPE VARCHAR(10)
RESULT SETS 1
PROGRAM TYPE MAIN
READS SQL DATA
WLM ENVIRONMENT DSNAPP01
DECLARE CUR1 CURSOR WITH RETURN FOR
WHERE FROM_DATE <= INDATE
AND TO_DATE >= INDATE
AND TRANSACTIONTYPE = INTYPE;
The procedure has been created and am able to view the entry in SYSIBM.SYSROUTINES.
When a call is made to this procedure , I get the following error:
ERROR  [IBM][DB2] SQL0444N Routine "INTERSP" (specific name "")
is implemented with code in library or path "", function ""
which cannot be accessed. Reason code: "". SQLSTATE=42724