Got Sqlcode=-981 while calling from COBOL pgm to Stored Proc

pkmurali · Active User Joined: 15 Dec 2005 Posts: 271

Dear all,

I got SQLCODE=-981 with the following error message

DSNT408I SQLCODE = -981, ERROR: THE SQL STATEMENT FAILED BECAUSE THE RRSAF CONNECTION IS NOT IN A STATE THAT ALLOWS SQL OPERATIONS, REASON 00C12219 DSNT418I SQLSTATE = 57015 SQLSTATE RETURN CODE DSNT415I SQLERRP = DSNARA00 SQL PROCEDURE DETECTING ERROR DSNT416I SQLERRD = 0 0 0 -1 0 0 SQL DIAGNOSTIC INFORMATION DSNT416 I SQLERRD = X'00000000' X'00000000' X'00000000' X'FFFFFFFF' X'00000000' X'00000000' SQL DIAGNOSTIC INFORMATION.

while calling a Store Procedure from COBOL Program. I have called the stored procedure as typical COBOL-DB2 Program as shown below

dbzTHEdinosauer · Posted: Thu May 28, 2009 7:35 pm

The Stored Procedure has been generated as requiring RRSAF type of attach.
Your CALLing program has not invoked an RRS connection with db2
or
the SP invocation methodology has not included an RRS connection.

I don't know which. Is this a MQS-DB2 application?

pkmurali · Active User Joined: 15 Dec 2005 Posts: 271

Can you please pitch it more on RRS?

dbzTHEdinosauer · Posted: Thu May 28, 2009 10:11 pm

READ about RRS here
ABCs of z/OS System Programming Volume 5

AND

READ abour RRS here
DB2 9 for z/OS Stored Procedures: Through the CALL and Beyond
or
DB2 for z/OS Stored Procedures: Through the CALL and Beyond

What Does your application deal with besides DB2? MQS?, IMS?

pkmurali · Active User Joined: 15 Dec 2005 Posts: 271

It deals with DB2 Stored Procedures.

dick scherrer · Posted: Fri May 29, 2009 7:29 pm

Hello,