DB2 Stored Procedure Results Error

[Former Member]

Hi Dudes,

I could able to connect the db2 stored procedure in crystal report 11 successfully without error.However my problem is, i could not able to view the result even though i pass the correct parameter.

Here is the snippet

CREATE PROCEDURE SP_CTYPING ( IN V_CO VARCHAR(3) ) 
LANGUAGE SQL 

BEGIN 

DECLARE C1 CURSOR FOR select  * from fafcty a inner join ccfcty cl on cl.co_f=a.clnt_f
WHERE INSL_CO_C= V_CO; 

OPEN C1 ; 

END

In crystal report i can able to connect this procedure without any error. I can see all fields of both fafcty,ccfcty tables at crystal report. When i try to run the report with correct parameter value, it returns empty record. Plz help to solve this error.

Thanks in Advance,

Suresh

[former_member11696 · Accepted solution]

Crystal requires a CURSOR to hold the data set. Not sure what the synax is for DB2 but search the help file and then it should work.