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
 

 

stored procedure execution causes -805

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

New User


Joined: 25 Apr 2009
Posts: 25
Location: chennai

PostPosted: Thu Nov 12, 2009 11:55 pm    Post subject: stored procedure execution causes -805
Reply with quote

hai i am executing one stored procedure(cobol-db2 in cics) from my cics program before that i called one more cics program through link.

that call was successfully executed but when i try to execute my stored procedure it gave -805.

and later i executed one quarry before my cics link call now the call and my stored procedure successfully executed with out any error.

can anyone explain why it gave -805 sqlcode if the main program does not have any quarry before my stored procedure call?
Back to top
View user's profile Send private message

wanderer

Active User


Joined: 05 Feb 2007
Posts: 199
Location: Sri Lanka

PostPosted: Sat Nov 14, 2009 1:02 am    Post subject:
Reply with quote

Here is some info about dynamic plan switching, syncpoints etc in CICS if you are using them.

http://publib.boulder.ibm.com/infocenter/cicsts/v3r1/index.jsp?topic=/com.ibm.cics.ts31.doc/dfhtk/dfhtk2a.htm

Also, when you get -805 you can see the SQLCA to find which PLAN is giving you the -805. Any debugger or something like abendaid or other tool will be useful.
Back to top
View user's profile Send private message
arunshan04

New User


Joined: 25 Apr 2009
Posts: 25
Location: chennai

PostPosted: Sun Nov 15, 2009 11:35 pm    Post subject:
Reply with quote

no i am not using any dynamic plan switching

the same plan when i try to execute my stored procedure it gave me -805
Back to top
View user's profile Send private message
arunshan04

New User


Joined: 25 Apr 2009
Posts: 25
Location: chennai

PostPosted: Sun Nov 15, 2009 11:40 pm    Post subject:
Reply with quote

when dfhpf3
exec cics
link (program)
end-exec
exec sql
call storedprocdure
end-exec
end-evaluate


the stored procedure call only ginving -805

exec sql
set :ws-timestamp = current timestamp
end-exec

later i add this querry in

when dfhpf3
exec sql
set :ws-timestamp = current timestamp
end-exec
exec cics
link (program)
end-exec
exec sql
call storedprocdure
end-exec
end-evaluate

now it is working fine...
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 Is the 'prompt' data for the DSLIST p... Willy Jensen TSO/ISPF 2 Tue Dec 06, 2016 4:38 am
No new posts Regarding COBOL Stored Procedure opti... selvamsrinivasan85 DB2 4 Fri Nov 04, 2016 8:57 pm
No new posts Access SQLCA fields inside a stored p... gangapd DB2 4 Thu Oct 27, 2016 10:20 am
No new posts Is possible to call subprogram from c... cmsmoon COBOL Programming 3 Fri Aug 05, 2016 6:46 pm
This topic is locked: you cannot edit posts or make replies. JCL MULTIPLE STEP EXECUTION QUERY Susanta JCL & VSAM 18 Sat Jul 30, 2016 1:17 pm


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