Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Cursor declaration in linkage section

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
vijay000

New User


Joined: 26 Jun 2006
Posts: 4

PostPosted: Thu Mar 19, 2009 11:05 am    Post subject: Cursor declaration in linkage section
Reply with quote

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?
Back to top
View user's profile Send private message

dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Thu Mar 19, 2009 7:49 pm    Post subject:
Reply with quote

Hello,

Try sending the number as alpha text rather than "comp".
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Updating Cursor row withour using FOR... chandan.inst DB2 15 Tue Nov 08, 2016 11:17 am
No new posts Variable for cursor names ravikumar15 DB2 5 Sun Jul 17, 2016 7:08 am
No new posts DB2 Stored Procedure - Dynamic SQL - ... GuyC DB2 2 Wed Feb 17, 2016 5:10 pm
No new posts ISREDIT - Position Cursor on the Comm... Tarique Anwer TSO/ISPF 5 Wed Feb 03, 2016 12:44 pm
No new posts Number of parameters in Linkage kregen COBOL Programming 4 Wed Jan 27, 2016 5:13 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us