Handling SQLCODE -811.

All sort of Mainframes Interview Questions.

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

Handling SQLCODE -811.

Postby 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
Has thanked: 10 times
Been thanked: 7 times

Re: Handling SQLCODE -811.

Postby 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: 2392
Joined: Sun Apr 21, 2013 7:40 pm
Location: Mumbai, India
Has thanked: 152 times
Been thanked: 66 times

Re: Handling SQLCODE -811.

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

Postby 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?




Return to “Interview Questions.”

Who is online

Users browsing this forum: CommonCrawl [Bot] and 0 guests