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

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

i want to know how the commit option works,how it save the changes? it will update the database or what ? where we can see these saved changes?

4 Answers  


i have one file having 100 of records? i want to display it like 20 records in one column and 20 records in another column total 40 records per page ? how ?

2 Answers   EDS,


What does db2 plan contain?

0 Answers  


What are the 2 sqlcodes that are returned?

0 Answers  


What is a buffer in memory?

0 Answers  


How do you retrieve the data from a nullable column?

2 Answers  


How can you split a table in to exactly half?

7 Answers   HSBC,


What does DML stand for and what are some examples of it?

3 Answers   IBM,


what is the steps followed in EXPLAIN Process or EXPLAIN command. (Explain is for identifying the optimized access path but how or what is the steps for doing the EXPLAIN)

4 Answers   IBM,


What is consistency token in db2?

0 Answers  


What is the difference between Primary key and unique index?

6 Answers  


What is check constraint in db2?

0 Answers  


Categories