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

Question Posted / wajid

Answers were Sorted based on User's Feedback

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

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

More DB2 Interview Questions

What are the full forms of spufi and dclgen and why are they used?

i have a db2 variable how do u declare tht into working storage section ?

What types of tables are there in the db2 database?

How do I add a column to an existing table in db2?

Shall i use this query to retrieve first 4 records, Select empno, sal from emptbl where empno < 5. like this can we fetch first 100 records?

What is buffer pool in the db2 database?

What are leaf pages?

Generally if I want to select the names starting with c I need to use c% But how could I code to select the data which contains % as a part of data.

what are stage one indexable predicates?

How do I copy a table in db2?

What are db2 error codes -305 and -407. What is the difference between these 2 error codes ?

1. what if null values retrived from database and no null indicator mentioned in query. What is sql code.

For more DB2 Interview Questions Click Here