mano
New User
Joined: 23 Mar 2006 Posts: 17 Location: chennai
|
|
|
|
Hi,
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
LANGUAGE SQL
PROGRAM TYPE MAIN
READS SQL DATA
COLLID MMSPPACK
WLM ENVIRONMENT DSNAPP01
PARA1: BEGIN
DECLARE CUR1 CURSOR WITH RETURN FOR
SELECT Col1,
Col2,
Col3,
FROM MM.Table1
WHERE FROM_DATE <= INDATE
AND TO_DATE >= INDATE
AND TRANSACTIONTYPE = INTYPE;
OPEN CUR1;
END PARA1
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 [42724] [IBM][DB2] SQL0444N Routine "INTERSP" (specific name "")
is implemented with code in library or path "", function ""
which cannot be accessed. Reason code: "". SQLSTATE=42724
Any clarification on topic is most welcome. |
|