IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

DB2 Stored Procedures-unable to retrieve result-stes


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
Terry Heinze

JCL Moderator


Joined: 14 Jul 2008
Posts: 1249
Location: Richfield, MN, USA

PostPosted: Mon Jun 08, 2009 5:43 pm
Reply with quote

takamal wrote:
Hi '

please send application program using stored procedure.i want know how its work.with compiler change.

kamal

send my personal mail-id kamal.removed

A bit selfish, don't you think?
Back to top
View user's profile Send private message
Raghu navaikulam

Active User


Joined: 27 Sep 2008
Posts: 193
Location: chennai

PostPosted: Mon Jun 08, 2009 10:21 pm
Reply with quote

Yes Terry Heinze

I agree with you.

Raghu
Back to top
View user's profile Send private message
rahuindo

New User


Joined: 09 Apr 2008
Posts: 83
Location: Chennai

PostPosted: Wed Jun 10, 2009 11:57 am
Reply with quote

Hi Guys,
Finally, i was able to solve the issue. I was in the assumption that the option "DYNAM" was the default in Changeman but it was just the reverse.
When i used the following compile options:
DYNAM, MAP,XREF, ATTACH(RRSAF)
i was able to solve the problem of SQLCODE -927 and -981.
Thanks a lot for all the support.
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


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

PostPosted: Thu Jun 11, 2009 4:13 am
Reply with quote

Good to hear it is working - thanks for letting us know icon_smile.gif

d
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2 Goto page Previous  1, 2

 


Similar Topics
Topic Forum Replies
No new posts Using Java/C/C++ to retrieve dataset ... Java & MQSeries 6
No new posts first column truncated in search result IBM Tools 13
No new posts SDSF like solution in EJES (store com... All Other Mainframe Topics 4
No new posts executing XCTL command in COBOL witho... CICS 10
No new posts Invoke stored procedure via batch JCL. DB2 2
Search our Forums:

Back to Top