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: 2446
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


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.”