View previous topic :: View next topic
|
Author |
Message |
arunshan04
New User
Joined: 25 Apr 2009 Posts: 25 Location: chennai
|
|
|
|
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 |
|
|
wanderer
Active User
Joined: 05 Feb 2007 Posts: 199 Location: Sri Lanka
|
|
Back to top |
|
|
arunshan04
New User
Joined: 25 Apr 2009 Posts: 25 Location: chennai
|
|
|
|
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 |
|
|
arunshan04
New User
Joined: 25 Apr 2009 Posts: 25 Location: chennai
|
|
|
|
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 |
|
|
|