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

stored procedure execution causes -805


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
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
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
Reply with quote

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

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
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
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts Capturing Job Execution Information All Other Mainframe Topics 3
No new posts Invoke stored procedure via batch JCL. DB2 2
No new posts Calling COBOL DB2 program from a COBO... COBOL Programming 2
No new posts Cond parameter and Rc code of a proce... JCL & VSAM 5
This topic is locked: you cannot edit posts or make replies. Internal Autonomous Stored Procedure ... DB2 6
Search our Forums:

Back to Top