DB2 Stored Procedures-unable to retrieve result-stes

Raghu navaikulam · Posted: Sat Jun 06, 2009 10:45 pm

Hi Dick

I noticed the ATTACH statement in the beginning of the pre-compile. I came to a conclusion that the LINKEDIT step the last one, so that may not be a problem. If it is not working, the ATTACH(RRSAF) for the client program's JCL has to be modified. Let him respond....

Thanks for your response.

Regards
Raghu

rahuindo · New User Joined: 09 Apr 2008 Posts: 83 Location: Chennai

Hi Dino,
I was not attaching RRSAF until i encountered this Error. As the explanation for the -981 suggested that the RRSAF connection may not be there. Hence i compiled the program and stored proc with ATTACH(RRSAF).

Raghu,
I link-edited the program as suggested by you.

Raghu navaikulam · Posted: Mon Jun 08, 2009 3:43 pm

Hi rahuindo

I think you have modified both the JCLs. Do not modify both. As I posted earlier, you just modify the JCL for Client program only. If you modify the SERVER program(STP) with DSNELI, you will get -927 sqlcode.

So make sure that you didn't modified both the JCLs.

For Server program -- use DSNRLI
For Client program -- use DSNELI.
For client program, you can avoid the use of ATTACH(RRSAF).

Post your resposnse.

Regards
Raghu

rahuindo · New User Joined: 09 Apr 2008 Posts: 83 Location: Chennai

Hi Raghu,
I am now trying to invoke the SP thru DB2I and on executing the SP, i constantly encounter the SQLCODE -981. I figured out to some extent the DSNRLI is not getting linked to the SP even though i have coded "INCLUDE SYSLIB(DSNRLI)" in the link-edit step. I can see that execution of each SQL Statements calls are made to DSNHLI instead of DSNRLI. I suspect this may be the reason for the SQLCODE -981.
Can anyone suggest that how can i modify my SP so that the calls are made to DSNRLI and not DSNHLI?

takamal · New User Joined: 10 Apr 2009 Posts: 4 Location: chennai

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

Terry Heinze · Posted: Mon Jun 08, 2009 5:43 pm

Raghu navaikulam · Posted: Mon Jun 08, 2009 10:21 pm

Yes Terry Heinze

I agree with you.

Raghu

rahuindo · New User Joined: 09 Apr 2008 Posts: 83 Location: Chennai

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.

dick scherrer · Posted: Thu Jun 11, 2009 4:13 am

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

d