vijay000
New User
Joined: 26 Jun 2006 Posts: 4
|
|
|
|
HI,
we are developing stored proc in cobol. We are having cursor declaration in linakge section.This is working fine,when alphanumeric is passed from calling program to declare cursor,and the same is not working if the variable used is comp data type.
The calling program here is java nad it sends an integer.
LINKAGE SECTION.
01 I-HH-NUM PIC S9(9) USAGE COMP.
EJECT
EXEC SQL
DECLARE HH_CLAIMS_CURSR CURSOR WITH RETURN FOR
SELECT *
FROM ASOI
WHERE
SOI_ID = :I-HH-NUM
WITH UR END-EXEC.
CREATE PROCEDURE SMEEEMP(I_HH_NUM INTEGER IN)
DYNAMIC RESULT SET 01
LANGUAGE COBOL
NOT DETERMINISTIC
EXTERNAL NAME "SMEEEMP"
Any suggestion? |
|