Handling SQLCODE -811.

All sort of Mainframes Interview Questions.
Previous topicNext topic

Topic Author
RajuRastogi
New Member
Posts: 4
Joined: Thu Apr 14, 2016 4:37 pm

Handling SQLCODE -811.

Post by RajuRastogi » Mon Oct 03, 2016 3:38 pm

Hi,

Is it possible that SQLCODE -811 occurs, even though cursor has been defined?

I know cursor is defined to handle -811 but can it still occur ina program even if cursor has been defined?

I don't know why would it happen,if it happens. Can somepme please asnwer me about this.




Chandan Yadav
Website Team
Website Team
Posts: 69
Joined: Wed Jul 31, 2013 10:19 pm
Zodiac: Libra

Re: Handling SQLCODE -811.

Post by Chandan Yadav » Tue Oct 04, 2016 9:34 am

It should not happen. Can you please post your SQL and cursor declaration where you are getting -811

Thanks,
Chandan



User avatar

Anuj Dhawan
Founder
Posts: 2612
Joined: Sun Apr 21, 2013 7:40 pm
Location: Mumbai, India
Zodiac: Sagittarius

Re: Handling SQLCODE -811.

Post by Anuj Dhawan » Tue Oct 04, 2016 11:15 am

It's an interview question I doubt he'd be able to post the SQL.


Thanks,
Anuj

Disclaimer: My comments on this website are my own and do not represent the opinions or suggestions of any other person or business entity, in any way.


Topic Author
RajuRastogi
New Member
Posts: 4
Joined: Thu Apr 14, 2016 4:37 pm

Re: Handling SQLCODE -811.

Post by RajuRastogi » Tue Oct 04, 2016 4:53 pm

Yes. I have been asked in an interview that Is it possible that SQLCODE -811 occurs, even though cursor has been defined?



Previous topicNext topic

Return to “Interview Questions.”