IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Is SQLCODE -811 possible while fetching a cursor?


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

New User


Joined: 18 Aug 2020
Posts: 1
Location: India

PostPosted: Tue Aug 18, 2020 12:19 am
Reply with quote

Hi,

While browsing an existing program (written a decade back), I found a piece of code where it is written - "IF SQLCODE = -811 ... PERFORM ABCD-PARA".

My question is - "Is it really possible to get SQLCODE = -811 while fetching a cursor in mainframe"?

As far as I know, to avoid more than one row, simple SELECTs are replaced by cursor (to avoid -811).
Back to top
View user's profile Send private message
Rohit Umarjikar

Global Moderator


Joined: 21 Sep 2010
Posts: 2727
Location: NYC,USA

PostPosted: Wed Aug 19, 2020 3:44 am
Reply with quote

Its one of those copy paste problem.
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

 


Similar Topics
Topic Forum Replies
No new posts Error while fetching the record from ... COBOL Programming 3
No new posts Restart logic by using cursor name in... DB2 1
No new posts Seeking Resolution for SQKCODE -991 o... DB2 2
No new posts Multiple rows within Cursor when Coun... DB2 14
No new posts Issue while fetching a column(Nullabl... DB2 18
Search our Forums:

Back to Top