is it possible to get -811 error when you use cursors. why?

Question Posted / wajid

2 Answers
6967 Views
IBM, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

is it possible to get -811 error when you use cursors. why?..

Answer / vaneesh khurana

When you are fetching cursor without declaration.

Is This Answer Correct ?

1 Yes

0 No

is it possible to get -811 error when you use cursors. why?..

Answer / purushothr

Yes it is possible only in cursor. if u trying to retrieve
more than one row at the same time by using cursor then -
811 error ll come.

Is This Answer Correct ?

6 Yes

14 No

Post New Answer

More DB2 Interview Questions

Can we insert update delete in view?

0 Answers

What is database alias db2?

0 Answers

Why cursor is used in db2?

0 Answers

My DB2 program first read the data from a file and then it look into a table with the data it got from the file.If we did not bind the program , should the file read before SQL execution be success??

2 Answers Xansa,

What is difference between isnull and coalesce?

0 Answers

What is an inner join, and an outer join ?

1 Answers CTA,

WHAT IS NULL INDICATOR ? WERE IS THIS USED? AND IF IT IS USED IN FILES CONCEPT? HOW DO WE USE IT?

2 Answers IBM,

Where are plans stored?

2 Answers

what happend with out using Commit,when closing cursor and program?

5 Answers CSC,

Do we have any optinon to search part of integer in DB2 as we have for character Like,SUBSTR optins?

1 Answers

What is buffer pool and list some of them?

0 Answers

What does the sqlcode of -818 pertain to?

3 Answers

For more DB2 Interview Questions Click Here