Portal | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Forum Index
 
Register
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Is SQLCODE -811 possible while fetching a cursor?

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
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    Post subject: Is SQLCODE -811 possible while fetching a cursor?
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: 2467
Location: NY,USA

PostPosted: Wed Aug 19, 2020 3:44 am    Post subject:
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    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 Restart logic by using cursor name in... Twinkle22 Mainframe Interview Questions 1 Wed Jul 29, 2020 11:26 am
No new posts Seeking Resolution for SQKCODE -991 o... tgwacker50 DB2 2 Mon Jun 22, 2020 8:25 pm
No new posts Multiple rows within Cursor when Coun... iamdijkstra007 DB2 14 Mon Jun 08, 2020 12:53 am
No new posts Issue while fetching a column(Nullabl... VINAY PALLELA DB2 18 Tue Mar 31, 2020 9:33 pm
No new posts SQLCODE=-204 SQLSTATE=42704 mughais27 DB2 4 Fri Feb 14, 2020 5:04 pm

Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us