View previous topic :: View next topic
|
Author |
Message |
Agni
New User
Joined: 22 Nov 2007 Posts: 83 Location: Chennai
|
|
|
|
Hi All,
One of my colleagues is facing the -981 SQL code when he tries to open the CURSOR in COBOL-DB2 program. I searched in the forum, there was only one post related to this SQL code, but there was no solution. If anybody knows how to solve this, please reply. It would be of great help. I have pasted the SQL code that he is getting.
Code: |
-981 THE SQL STATEMENT FAILED BECAUSE THE RRSAF CONNECTION IS NOT IN A STATE THAT ALLOWS SQL OPERATIONS.
|
Agni |
|
Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10873 Location: italy
|
|
|
|
did Your friend talk with system support? |
|
Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10873 Location: italy
|
|
|
|
hit enter too quickly
Quote: |
-981 THE SQL STATEMENT FAILED BECAUSE THE RRSAF CONNECTION IS NOT IN A
STATE THAT ALLOWS SQL OPERATIONS, REASON reason-code.
Explanation: The application attempted to execute an SQL operation, but the RRSAF connection was not in a state that allows the processing of SQL statements.
System Action: The statement cannot be executed.
Programmer Response: See reason-code in "DB2 codes" in topic 3.0 for an explanation of the problem. Correct the error in the application, REBIND, and run the application again. |
the reason code is misssing, the reason code is an essential information forra better insight of the problem |
|
Back to top |
|
|
Agni
New User
Joined: 22 Nov 2007 Posts: 83 Location: Chennai
|
|
|
|
Hi E.S,
Can you tell me what is this error? Why he needs to talk with system support? I am not good in DB2, so it will be helpful to me if you explain what does this error actually mean? i will convey the same to him also.
Thanks
Agni |
|
Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10873 Location: italy
|
|
|
|
why doesn' t your colleague speak by himself...
I am posting on behalf of
I am telling what I understood he said,
but maybe I made a mistake reporting what he said,
You tell me
I will tell him
he did not understand what You told me to tell him
he asked why You asked me to ask him ...
and so on and so on
if somedody has a problem he should be able to report it himself |
|
Back to top |
|
|
Agni
New User
Joined: 22 Nov 2007 Posts: 83 Location: Chennai
|
|
|
|
Hi E.S,
The reason behind this is he is not a member of our forum. Also, he doesn't have access internet in his office.
thanks
Agni |
|
Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10873 Location: italy
|
|
|
|
as I said in a previous post what is the reason code ?
looking at the manuals is a good way to get a better understanding of things
and a way of getting better and more friendly answers on any forum
after all the forum is not a manual reading service .. isn' t it
Does your friend have the db2 manuals available ?
does his support have the manuals available ? |
|
Back to top |
|
|
|