IBM Mainframe Forum Index
 
Register
 
IBM Mainframe Forum Index Mainframe: Search Log in to check your private messages Log in
 

Seeking Resolution for SQKCODE -991 on Open Cursor


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
tgwacker50

New User


Joined: 22 Jun 2020
Posts: 3
Location: USA

PostPosted: Mon Jun 22, 2020 8:25 pm
Reply with quote

I am receiving a SQLCODE -991 on an OPEN CURSOR statement. The OPEN is in a COBOL program initialization process. The program is not called by another program. The format of the open is:
EXEC SQL
DECLARE cursor-name CURSOR FOR
SELECT column-name1, column-name2, …
FROM table-name
WHERE column-name = 0
ORDER BY column-name
END-EXEC
immediately after issuing the Coen statement, the SQLCODE is checked and that is when the -991 is detected.
Back to top
View user's profile Send private message
sergeyken

Active Member


Joined: 29 Apr 2008
Posts: 879
Location: Maryland

PostPosted: Mon Jun 22, 2020 10:14 pm
Reply with quote

RTFM:

IBM Knowledge Center
Quote:
-991 CALL ATTACH WAS UNABLE TO ESTABLISH AN IMPLICIT CONNECT OR OPEN TO DB2. RC1= rc1 RC2= rc2


Explanation

Call attach attempted to perform an implicit connect and open as the result of an SQL statement. The connect or open failed with the returned values. rc1The value returned in FRBRC1 for the failed CONNECT or OPEN request.rc2 The value returned in FRBRC2 for the failed CONNECT or OPEN request.


System action

The statement cannot be processed.


Programmer response

Verify that the application intended to use the call attachment facility (CAF) as the mechanism to connect to DB2®. For functions or stored procedures running in the WLM-established stored procedure address space the application must be link-edited with or dynamically allocate the RRS attachment language interface module (DSNRLI), not CAF.


SQLSTATE

57015
Back to top
View user's profile Send private message
Rohit Umarjikar

Global Moderator


Joined: 21 Sep 2010
Posts: 2508
Location: NY,USA

PostPosted: Tue Jun 23, 2020 7:13 pm
Reply with quote

Your login ID needs a GRANT access to the Plan.
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

 

Search our Forum:

Similar Topics
Topic Forum Replies
No new posts IGZ0035S THERE WAS AN UNSUCCESSFUL OP... COBOL Programming 3
No new posts Is SQLCODE -811 possible while fetchi... DB2 1
No new posts Restart logic by using cursor name in... DB2 1
No new posts VSAM Open During Copy-Excessive EXCP ... JCL & VSAM 1
No new posts Multiple rows within Cursor when Coun... DB2 14

Back to Top