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

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

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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is a trigger in the db2 database?

1029

can all users have the privilage to use the sql statement select * (dml)?

1123

What is bind plan?

998

How can the firstname and the lastname from the emp table be concatenated to generate complete names?

1244

ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE

2021

What is dbrm in db2 database?

1052

How can you find out the # of rows updated after an update statement?

1075

Explain about cursor stability?

994

Can you tell me how can you find out the # of rows updated after an update statement?

1055

Is db2 a database?

923

What does db2 blu stand for?

1112

What does db2 plan contain?

973

Is ibm db2 free?

963

Which component is responsible for db2 startup and shutdown?

989

What is a db2 tablespace?

1014