Yes it is possible only in cursor. if u trying to retrieve more than one

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

Question Posted / purushothr

Answer Posted / 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

Please Help Members By Posting Answers For Below Questions

What is the role of union all and union

1103

What is commit in db2?

1027

What is the difference between nvl and coalesce?

1048

Explain the contention situations caused by locks?

1050

What are the various isolation levels possible?

1099

What is the result of open cursor statement?

1071

In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?

1079

Describe major components of db2?

1082

Define data page.

1048

What is bind package and plan in db2?

1040

What is with ur in db2?

1285

Differentiate between cs and rr isolation levels? Where do you specify them?

1046

Why cursor is used in db2?

1019

What is host variable?

1036

How to access db2 tables in mainframe?

1029