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
 

 

Getting -981 SQL code

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

New User


Joined: 22 Nov 2007
Posts: 83
Location: Chennai

PostPosted: Fri Feb 15, 2008 6:53 pm    Post subject: Getting -981 SQL code
Reply with quote

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
View user's profile Send private message

enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10234
Location: italy

PostPosted: Fri Feb 15, 2008 6:56 pm    Post subject: Reply to: Getting -981 SQL code
Reply with quote

did Your friend talk with system support?
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10234
Location: italy

PostPosted: Fri Feb 15, 2008 7:00 pm    Post subject: Reply to: Getting -981 SQL code
Reply with quote

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
View user's profile Send private message
Agni

New User


Joined: 22 Nov 2007
Posts: 83
Location: Chennai

PostPosted: Fri Feb 15, 2008 7:01 pm    Post subject: Reply to: Getting -981 SQL code
Reply with quote

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
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10234
Location: italy

PostPosted: Fri Feb 15, 2008 7:09 pm    Post subject: Reply to: Getting -981 SQL code
Reply with quote

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
View user's profile Send private message
Agni

New User


Joined: 22 Nov 2007
Posts: 83
Location: Chennai

PostPosted: Fri Feb 15, 2008 7:20 pm    Post subject: Reply to: Getting -981 SQL code
Reply with quote

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
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10234
Location: italy

PostPosted: Fri Feb 15, 2008 7:25 pm    Post subject: Reply to: Getting -981 SQL code
Reply with quote

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 icon_biggrin.gif

Does your friend have the db2 manuals available ?
does his support have the manuals available ?
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 JCL to Set Return code based on DB2 S... vinu78 DB2 17 Mon Mar 13, 2017 9:47 pm
No new posts IMS region inactive - User abend code... gthmrj IMS DB/DC 5 Tue Mar 07, 2017 12:29 pm
No new posts CA Workload Automation event code help vinu78 CA Products 10 Wed Mar 01, 2017 10:05 am
No new posts MAX-RC 88 and Return code 606 in DFH0... lind sh CICS 2 Tue Jan 24, 2017 1:23 pm
No new posts How to Capture the Max return code of... anilkumar922 All Other Mainframe Topics 2 Thu Jan 12, 2017 12:02 pm


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